T-sql 时间操作

阿里云服务器新人优惠：

新购链接：https://www.aliyun.com/acts/limit-buy?userCode=ge65ec6y

更多优惠，请联系17303219823（微信号）

T-sql 分解时间，获取年、月、日、时、分、秒

 

declare @year int
    declare @month int
    declare @day int
    declare @hour int
    declare @minute int
    declare @second int
    declare @datetime date
    set @year=(DATENAME(YEAR,(getdate())))
    set @month=(DATENAME(MONTH,(getdate())))
    set @day=(DATENAME(DAY,(getdate())))
    set @hour=(DATENAME(HOUR,(getdate())))
    set @minute=(DATENAME(MINUTE,(getdate())))
    set @second=(DATENAME(SECOND,(getdate())))
    set @datetime=(Convert(varchar(100),GETDATE(),23))
    
    select @year,@month

t-sql 获取本周星期一到星期日：

declare @zhouyi datetime,@zhouer datetime,@zhousan datetime,@zhousi datetime,@zhouwu datetime,@zhouliu datetime,@zhoutian datetime
set @zhouyi=(select CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 0),121))
set @zhouer=(select CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 1),121))
set @zhousan=(select CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 2),121))
set @zhousi=(select CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 3),121))
set @zhouwu=(select CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 4),121))
set @zhouliu=(select CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 5),121))
set @zhoutian=(select CONVERT(nvarchar(10), DATEADD(wk, DATEDIFF(wk,0,DATEADD(dd, -1, getdate()) ), 6),121))
select @zhoutian

 

可以作为数据统计