如何查看日期beetwen另外两个日期？ [英] how to check date beetwen two other date?

问题描述

亲爱的先生，

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屋！