sqlserver 添加当前时间到末尾列

--add column todaytime

SELECT top 1

GETDATE() as todaytime,

CURRENT_TIMESTAMP as todaytime,

DATEADD(day,-1, GETDATE()) as yesterdaytime,

DATEADD(day,-1, CURRENT_TIMESTAMP) as yesterdaytime

FROM

Sys_LoggerOperate

 

--add column todaydate

SELECT top 1

CONVERT(DATE, GETDATE()) as today,

CAST(CURRENT_TIMESTAMP AS DATE) as today,

DATEADD(day,-1, CONVERT(DATE, GETDATE())) as yesterday,

DATEADD(day,-1, CAST(CURRENT_TIMESTAMP AS DATE)) as yesterday

FROM

Sys_LoggerOperate