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 |
|
drpkrupa
Yak Posting Veteran
74 Posts |
 Posted - 2010-01-07 : 14:32:09
|
| I want to dispaly following data out put.Thursday, January 7, 2010How can i write sql which return above string. |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2010-01-07 : 14:45:29
|
| [code]select datename(dw,getdate()) + ', ' + datename(month,getdate()) + ' ' + datename(dd,getdate()) + ', ' + convert(varchar(4),getdate(),120)[/code]However, You should ideally be doing these formatting in your front end. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-01-08 : 02:24:06
|
quote:
Originally posted by drpkrupa
I want to dispaly following data out put.Thursday, January 7, 2010How can i write sql which return above string.
Where do you want to show formatted dates?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Data format