Hi Neethu,
As per your query i have created sample. Please check the below sample.
If you have any query please revert me back.
SQL
-- Current time does not falls between start time and end time
DECLARE @ST DATETIME, @ET DATETIME
SET @ST='12:00:00 AM'
SET @ET='6:00:00 AM'
IF(CONVERT(VARCHAR(8),GETDATE(),108) BETWEEN CONVERT(VARCHAR(8),CONVERT(DATETIME, @ST, 0),108) AND CONVERT(VARCHAR(8),CONVERT(DATETIME, @ET, 0),108))
SELECT 'YES' TimeCheck, CONVERT(VARCHAR(8),GETDATE(),108) CurrentTime
ELSE
SELECT 'NO' TimeCheck, CONVERT(VARCHAR(8),GETDATE(),108) CurrentTime
-- Current time falls between start time and end time
SET @ST='12:00:00 AM'
SET @ET='6:00:00 PM'
IF(CONVERT(VARCHAR(8),GETDATE(),108) BETWEEN CONVERT(VARCHAR(8),CONVERT(DATETIME, @ST, 0),108) AND CONVERT(VARCHAR(8),CONVERT(DATETIME, @ET, 0),108))
SELECT 'YES' TimeCheck, CONVERT(VARCHAR(8),GETDATE(),108) CurrentTime
ELSE
SELECT 'NO' TimeCheck, CONVERT(VARCHAR(8),GETDATE(),108) CurrentTime
Output
TimeCheck |
CurrentTime |
NO |
14:08:49 |
TimeCheck |
CurrentTime |
YES |
14:08:49 |