Home >Database >Mysql Tutorial >sql查询计算给定日期是当年的第几周语句
sql查询计算给定日期是当年的第几周语句
- WBOYOriginal
- 2016-06-07 17:47:451904browse
sql查询计算给定日期是当年的第几周语句
sql查询计算给定日期是当年的第几周语句
declare @date datetime;
set @date = getdate()
select datepart(week,@date) [weekofyear]; --返回int型
select datename(week,@date) [weekofyear]; --返回varchar型
go
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：查询年初，年末，去年年初，明年年初与年末sql语句Next article：sql判断null Oracle,sql server