#ref-menu
CONVERT function is used to change or convert the DateTime formats.By using
convert function you can get only Date part or only Time part from the
DateTime.
CONVERT Function Syntax:
CONVERT(data_type,expression,date
Format style)
|
Format |
Query |
|
dd mon yy |
select convert(varchar, getdate(), 6) |
|
Mon dd, yy |
select convert(varchar, getdate(), 7) |
|
mon dd yyyy hh:miAM (or PM) |
select convert(varchar, getdate(), 100) |
|
mm/dd/yyyy |
select convert(varchar, getdate(), 101) |
|
yyyy.mm.dd |
select convert(varchar, getdate(), 102) |
|
dd/mm/yyyy |
select convert(varchar, getdate(), 103) |
|
dd.mm.yyyy |
select convert(varchar, getdate(), 104) |
|
dd-mm-yyyy |
select convert(varchar, getdate(), 105) |
|
dd mon yyyy |
select convert(varchar, getdate(), 106) |
|
Mon dd, yyyy |
select convert(varchar, getdate(), 107) |
|
hh:mm:ss |
select convert(varchar, getdate(), 108) |
|
Default + milliseconds mon dd yyyy
hh:mi:ss:mmmAM (or PM) |
select convert(varchar, getdate(), 109) |
|
mm-dd-yyyy |
select convert(varchar, getdate(), 110) |
|
yyyy/mm/dd |
select convert(varchar, getdate(), 111) |
|
yyyymmdd |
select convert(varchar, getdate(), 112) |
|
hh:mi:ss:mmm(24h) |
select convert(varchar, getdate(), 114 |
