CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm' : Date Format « Date Timezone « SQL Server / T-SQL






CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm'


3> SELECT TOP 1 GETDATE() 'Default',
4>     CONVERT(varchar,GETDATE(),108) 'hh:mm:ss',
5>     CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm',
6>     CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy hh:mm:ss:mmm'
7> GO
Default                 hh:mm:ss                       hh:mm:ss:mmm                   dd Mmm yyyy hh:mm:ss:mmm
----------------------- ------------------------------ ------------------------------ ------------------------------
2006-10-12 07:15:07.950 07:15:07                       07:15:07:950                   12 Oct 2006 07:15:07:950

(1 rows affected)
           
       








Related examples in the same category

1.CONVERT(varchar, getdate(), 1(2,3,4,5,6))
2.CONVERT(varchar,GETDATE(),108) 'hh:mm:ss'
3.CONVERT(varchar,GETDATE(),114) 'hh:mm:ss:mmm'
4.CONVERT(VarChar(50), GETDATE(), 104)
5.CONVERT(VarChar(50), GETDATE(), 103)
6.CONVERT(VarChar(50), GETDATE(), 100)
7.CONVERT(VarChar(50), GETDATE(), 101)
8.CONVERT(VarChar(50), GETDATE(), 102)
9.Reference Date data type as string (char)
10.Format date: 'Mmm dd yyyy hh:mmdp'
11.Format date: 'mm/dd/yyyy'