SQL just check the date with todays Date

Question

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