SQL只需检查今天日期的日期 [英] SQL just check the date with todays Date

问题描述

亲爱的，



我有三列LeaveFrom，LeaveUpto和EmployeeNumber。我将如何查看今天的日期天气今天的员工是否休假。



如何在SQL中执行此操作请帮助我。



谢谢

Basit

Dear,

I have three columns LeaveFrom , LeaveUpto and EmployeeNumber. How i will check with the today date weather the today employees on leave or not.

How to do this in SQL please help me.

Thanks
Basit

推荐答案

尝试：

Try:

SELECT * FROM MyTable WHERE GETDATE() BETWEEN LeaveFrom AND LeaveUpTo

这篇关于SQL只需检查今天日期的日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！