SELECT CONVERT(VARCHAR , GETDATE (), 120 )
2012-12-08 09:51:22
SELECT replace(REPLACE (REPLACE (CONVERT(VARCHAR , GETDATE (), 120 ),'-',''),'',''),':','')
20121208 095139
SELECT CONVERT(VARCHAR (12) , GETDATE (), 111 )
2012/12/08
SELECT CONVERT(VARCHAR (12) , GETDATE (), 112 )
20121208
SELECT CONVERT(VARCHAR (12) , GETDATE (), 102 )
2012.12.08
SELECT CONVERT(VARCHAR (12) , GETDATE (), 101 )
12/08/2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 103 )
08/12/2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 104 )
08.12.2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 105 )
08-12-2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 106 )
08 Dec 2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 107 )
Dec 08, 2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 108 )
09:54:50
SELECT CONVERT(VARCHAR (12) , GETDATE (), 109 )
Dec 8 2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 110 )
12-08-2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 113 )
08 Dec 2012
SELECT CONVERT(VARCHAR (12) , GETDATE (), 114 )
09:56:03:770