阅读背景:

Getting the first day in a week with T-SQL

来源:互联网 

A colleague just asked me if I knew a way to get the first day in a week in SQL Server. While I'm sure that there are many ways to get the first day (date) in a week here is a very simple way that in my opinion is quite elegant. The example assumes that you want to get the date of the first day in the week that GETDATE() is in. You could of course replace GETDATE() with a column of the datetime type.A colleague just asked me if I knew a way to ge




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: