| How to
sql format datetime without century? |
|
The following
conversion options are available for sql datetime format without century. Note that some conversions do include century. They are listed for completeness of the 0 - 25 option range:
select [Datetime] = convert(char, getdate(), 0) --mon dd yyyy hh:mmAM (or PM)
select [Datetime] = convert(char, getdate(), 1) --mm/dd/yy
select [Datetime] = convert(char, getdate(), 2) --yy.mm.dd
select [Datetime] = convert(char, getdate(), 3) --dd/mm/yy
select [Datetime] = convert(char, getdate(), 4) --dd.mm.yy
select [Datetime] = convert(char, getdate(), 5) --dd-mm-yy
select [Datetime] = convert(char, getdate(), 6) --dd mon yy
select [Datetime] = convert(char, getdate(), 7) --mon dd, yy
select [Datetime] = convert(char, getdate(), 8) --hh:mm:ss
select [Datetime] = convert(char, getdate(), 9) --mon dd yy hh:mm:ss:mmmAM (or PM)
select [Datetime] = convert(char, getdate(), 10) --mm-dd-yy
select [Datetime] = convert(char, getdate(), 11) --yy/mm/dd
select [Datetime] = convert(char, getdate(), 12) --yymmdd
select [Datetime] = convert(char, getdate(), 13) --dd mon yyyy hh:mm:ss:mmm
select [Datetime] = convert(char, getdate(), 14) --hh:mm:ss:mmm(24h)
select [Datetime] = convert(char, getdate(), 20) --yyyy-mm-dd hh:mm:ss(24h)
select [Datetime] = convert(char, getdate(), 21) --yyyy-mm-dd hh:mm:ss.mmm
select [Datetime] = convert(char, getdate(), 22) --mm/dd/yy hh:mm:ss AM (or PM)
select [Datetime] = convert(char, getdate(), 23) --yyyy-mm-dd
select [Datetime] = convert(char, getdate(), 24) --hh:mm:ss
select [Datetime] = convert(char, getdate(), 25) --yyyy-mm-dd hh:mm:ss.mmm
|
| The World Leader
in SQL Server Training |
|