8
Reply

SQL just check the date with todays Date

basit khan

basit khan

Jun 17 2015 4:17 AM
591
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.
Select * from Trn_EmployeeLeave Where LeaveFrom between Today.Date and Today.Date and LeaveUpto between Today.Date and Today.Date and EmployeeNumber=1 But His leave start from 01-Jun-2015 to 31-Aug-2015 how to check this 
 
Thanks
Basit

Answers (8)