I know it's basic question and experts can answer it very easily. I am new Leaer on SQL
I want to check either my Current DateTime is between two DateTimes Or Not.
Let us say I have First time '2016-05-19 04:23:00.000' and Second time is '2016-05-19 04:50:00.000'.
If Current DateTime is Between First Time and Second Time Retu True else Retu False.
Please Help me to write this query.