Home Forums SQL Server 2008 SQL Server 2008 - General Date format RE: Date format
Ant-Green
SSC Guru
Points: 113445
More actions
December 19, 2012 at 8:17 am
#1570109
then do what you where doing in the first place, this is how it outputs
SELECT '(Expires '+RTRIM(DATENAME(MM, GETDATE() ) + RIGHT(CONVERT(VARCHAR(12), GETDATE() ,107),9))+ ')'
(Expires December 19, 2012)