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 |
|
sushma patle
Starting Member
15 Posts |
 Posted - 2008-05-21 : 05:25:48
|
| IN THIS QUERYSELECT DATENAME(MM, GETDATE()) + RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9) AS [Month DD, YYYY]O/PJuly 04, 2006 RIGHT(CONVERT(VARCHAR(12), GETDATE(), 107), 9)PLEASE DISCRIBE ME WHAT HAPPEN IN THAT PLACE spatle |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-21 : 05:33:36
|
| You really dont need to do this. You just need :-SELECT CONVERT(VARCHAR(12), GETDATE(), 107)this will give you the current date in Month DD,YYYY format |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-21 : 05:38:10
|
Not really. Style 107 truncates month name to first three characters.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
DATE TIME