获取两个日期之间每个星期五的数据 [英] Get data for every friday between two dates
本文介绍了获取两个日期之间每个星期五的数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个SQL Server数据库,我希望从两个给定日期之间的VL_DR列中获取数据,并且该日期为星期五。
I have a SQL-Server database in wich i want to get the data from the column VL_DR between two given dates and where the date is a friday.
"SELECT VL_DR FROM table_VL WHERE date>='" + date_start
+ "' AND date<='" + date_end
+ "' AND DATENAME(dw, date)='Friday'"
但是在请求之后,我有一个空列表,同时我应该有一些值。
应该如何解决才能获得正确的请求?
But after the request I have an empty list while I should have some values. What should I fix to get the correct request?
推荐答案
如果是SQL Server
If its SQL Server
尝试
从table_VL WHERE([date] date_start和date_end之间)和LOWER(DATENAME(dw) ,[date]))='星期五'
如果其MySQL
尝试
从table_VL WHERE([date] date_start和date_end之间)和DAYNAME([date])='Friday'
这篇关于获取两个日期之间每个星期五的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文