Page is a not externally linkable
- Code, Content, and Presentation
---- MS SQL Server SQL For Converting Date to GMT Format
IanTurner - 11:44 am on Apr 3, 2011 (gmt 0)Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4291436.htm
SELECT Left(DateName(Weekday,getdate()),3) + ', ' + CONVERT(CHAR(20),getdate(),113) + ' GMT'
I hope this is useful to someone as I couldn't find it anywhere else on the net.
Output Format is
Sun, 03 Apr 2011 12:42:04 GMT
Brought to you by WebmasterWorld: http://www.webmasterworld.com