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 |
|
rgombina
Constraint Violating Yak Guru
319 Posts |
 Posted - 2007-10-04 : 15:38:15
|
| Hello,How can I format date to display alpha string such as 'Monday' instead of day '3' (mm/3/yyyy).Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-04 : 15:49:44
|
| Take look at datepart function. |
 |
|
|
rgombina
Constraint Violating Yak Guru
319 Posts |
Posted - 2007-10-04 : 15:49:44
|
Never mind... I forgot this function.print datename(weekday,getdate())print datename(dw,getdate())------------------------*/ThursdayThursday |
|
|
|
|
|
|
Alpha format day