Home >Database >Mysql Tutorial >sql 计算给定日期是当年的第几天语句
sql 计算给定日期是当年的第几天语句
- WBOYOriginal
- 2016-06-07 17:47:412354browse
sql 计算给定日期是当年的第几天语句
sql 计算给定日期是当年的第几天语句
declare @date datetime;
set @date = getdate()
select datepart(dayofyear,@date) [dayofyear];
select datename(dayofyear,@date) [dayofyear];
--另一种思路：当前日期与上年最后一天差的天数
select datediff(day,dateadd(year,datediff(year,0,@date),-1),@date)[dayofyear]
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：mssql server sql分页存储过程Next article：一次删除多条记录的sql语句