datetime
smalldatetime -- 精确到分钟
select DATEADD(day, 1,'2012-02-18 00:00:00.000')
select DATEPART(YEAR,'2012-02-18 00:00:00.000')
select DAY('2012-02-18 00:00:00.000')
select MONTH('2012-02-18 00:00:00.000')
select YEAR('2012-02-18 00:00:00.000')
select CONVERT(varchar,getdate(), 120) -- 当第二个输入为日期类型的时候,style参数才起作用
select CONVERT(datetime,'2012-02-18 01:20:33.120', 120)-- style参数没有作用
select *from stop_actlwhereCONVERT(varchar, ArrivalTime, 101)='02/01/2012' -- 找到发生在02/01/2012的数据
select convert(varchar(19), (SELECT DATEADD(MINUTE, -datepart(TZoffset,sysdatetimeoffset()), CURRENT_TIMESTAMP)), 20)