CONVERT(varchar,GETDATE(),108) 'hh:mm:ss'
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(),114) 'hh:mm:ss:mmm' | | |
3. | CONVERT(varchar,GETDATE(),113) 'dd Mmm yyyy 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' | | |