sql获取日期

最新推荐文章于 2025-08-11 21:13:32 发布

转载最新推荐文章于 2025-08-11 21:13:32 发布 · 350 阅读

文章标签：

#sql

JobDiary 专栏收录该内容

40 篇文章

订阅专栏

本文介绍了一种使用SQL来处理日期时间的方法，并通过具体示例展示了如何获取当前日期的不同时间范围（如日、周、月），同时利用这些时间戳进行数据聚合，例如计算特定时间段内的用户得分总和。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

declare
@aa varchar(20)
set @aa= CONVERT(varchar(100), GETDATE(), 23)
--//日

print @aa+' 0:00:00.000'
print @aa+' 23:59:59.999'
--//周
print CONVERT(varchar(100), DATEADD(wk, DATEDIFF(wk,0,getdate()), 0), 23)+' 0:00:00.000'
print CONVERT(varchar(100), DATEADD(wk, DATEDIFF(wk,0,getdate()), 6), 23)+' 23:59:59.999'
--//月

print CONVERT(varchar(100), DATEADD(m, DATEDIFF(m,0,getdate()), 0), 23)+' 0:00:00.000'
print CONVERT(varchar(100), DATEADD(m, DATEDIFF(m,0,getdate()), 30), 23)+' 23:59:59.999'

select distinct (userid),sum(score) as SumScore from ph where endTime between @aa+' 0:00:00.000' and @aa+' 23:59:59.999' group by userid order by SumScore desc
select distinct (userid),sum(score) as SumScore from ph where endTime between CONVERT(varchar(100), DATEADD(wk, DATEDIFF(wk,0,getdate()), 0), 23)+' 0:00:00.000' and CONVERT(varchar(100), DATEADD(wk, DATEDIFF(wk,0,getdate()), 6), 23)+' 23:59:59.999' group by userid order by SumScore desc
select distinct (userid),sum(score) as SumScore from ph where endTime between CONVERT(varchar(100), DATEADD(wk, DATEDIFF(wk,0,getdate()), 0), 23)+' 0:00:00.000' and CONVERT(varchar(100), DATEADD(wk, DATEDIFF(wk,0,getdate()), 6), 23)+' 23:59:59.999' group by userid order by SumScore desc