Format
|
Query
|
USA mm/dd/yy
|
select convert(varchar, getdate(), 1)
|
ANSI yy.mm.dd
|
select convert(varchar, getdate(), 2)
|
British/French dd/mm/yy
|
select convert(varchar, getdate(), 3)
|
German dd.mm.yy
|
select convert(varchar, getdate(), 4)
|
Italian dd-mm-yy
|
select convert(varchar, getdate(), 5)
|
dd mon yy
|
select convert(varchar, getdate(), 6)
|
Mon dd, yy
|
select convert(varchar, getdate(), 7)
|
USA mm-dd-yy
|
select convert(varchar, getdate(), 10)
|
JAPAN yy/mm/dd
|
select convert(varchar, getdate(), 11)
|
ISO yymmdd
|
select convert(varchar, getdate(), 12)
|
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)
|
Europe default + milliseconds dd mon yyyy hh:mm:ss:mmm(24h)
|
select convert(varchar, getdate(), 113) or select convert(varchar, getdate(), 13)
|
hh:mi:ss:mmm(24h)
|
select convert(varchar, getdate(), 114)
|
Làm tròn datetime
select DateAdd(Day, Datediff(Day,0, GetDate()), 0)
kq: 2015-07-09 00:00:00.000
select DateAdd(Day, Datediff(Day,0, GetDate()), 0)
kq: 2015-07-09
select cast(floor(cast(getdate() as float)) as datetime)
kq: 2015-07-09 00:00:00.000
