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 |
No comments:
Write comments