Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tart_SQL
Starting Member
41 Posts |
 Posted - 2008-08-13 : 15:59:50
|
| I have this code =CDate(Now).ToString("dd-MM-yyyy hh:mm:ss tt")which displays date in this format 04-05-2008 01:21:20 AM.What do I do to have it display in this format Tuesday, April 5, 2008 01:21:20 AM.Thanks. |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-13 : 20:29:20
|
| =CDate(Now).ToString("D") + " " + CDate(Now).ToString("hh:mm:ss tt") |
 |
|
|
|
|
|
need date formula