一、日期函数

介绍 : 对日期和时间输入值运算，返回字串、数字或日期和时间值

● CURRENT_TIMESTAMP 函数 : 返回包含电脑的日期和时间的datetime2[7]

SELECT CAST(CURRENT_TIMESTAMP AS DATE) AS TODAY;

执行结果

SELECT CAST(CURRENT_TIMESTAMP AS TIME) AS TIME;

执行结果

SELECT CURRENT_TIMESTAMP ;

执行结果

● DATEPART函数 : 可以从完整的日期资料中撷取出某部分

SELECT CURRENT_TIMESTAMP ,DATEPART(YEAR, CURRENT_TIMESTAMP) AS '年',DATEPART(MONTH, CURRENT_TIMESTAMP) AS '月',DATEPART(DAY, CURRENT_TIMESTAMP) AS '日',DATEPART(HOUR, CURRENT_TIMESTAMP) AS '时',DATEPART(MINUTE, CURRENT_TIMESTAMP) AS '分',DATEPART(SECOND, CURRENT_TIMESTAMP) AS '秒';