如何查看日期beetwen另外两个日期? [英] how to check date beetwen two other date?
本文介绍了如何查看日期beetwen另外两个日期?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
i想检查是select_date是beetwen relase_date和remove_date ......
plz help ...
解决方案
取决于你想怎么做 - 我们可以看到你的屏幕,所以我们无法分辨!
在C#中代码:
DateTime now = DateTime.Now;
如果(release_date < = now&& now < = remove_date)
{
...但在SQL中:
SELECT * FROM MyTable WHERE GETDATE () BETWEEN release_date AND remove_date
dear sir,
i want to check is selected_date is beetwen relase_date and remove_date...
plz help...
解决方案
Depends on how you want to do it - and we can;t see your screen, so we can't tell!
In C# code:
DateTime now = DateTime.Now; if (release_date <= now && now <= remove_date) { ...But in SQL:
SELECT * FROM MyTable WHERE GETDATE() BETWEEN release_date AND remove_date
这篇关于如何查看日期beetwen另外两个日期?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文