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:29 am
#1570116
DECLARE @Expiry_Date DATETIME = '2012-12-25 00:00:01.003'
SELECT '(Expires '+RTRIM(DATENAME(MM, @Expiry_Date ) + RIGHT(CONVERT(VARCHAR(12), @Expiry_Date ,107),9))+ ')'
Gives me an output of
(Expires December 25, 2012)