SQL lite query for get the records in which current time range exist between range of time slots
From: <smallubotlla_at_gmail.com>
Date: Fri, 29 Apr 2016 05:59:43 -0700 (PDT)
Message-ID: <234e6ece-61c4-43aa-b005-9c7b47e972e5_at_googlegroups.com>
The requirement is to get the time slot from sql table with the help of current time . Here is the table below . The problem arises when i am trying to get the time slot that surpasses 24th hours for example like the Night shift . if my current time is 21:00 i am unable to get the time slot . query made so far
Date: Fri, 29 Apr 2016 05:59:43 -0700 (PDT)
Message-ID: <234e6ece-61c4-43aa-b005-9c7b47e972e5_at_googlegroups.com>
The requirement is to get the time slot from sql table with the help of current time . Here is the table below . The problem arises when i am trying to get the time slot that surpasses 24th hours for example like the Night shift . if my current time is 21:00 i am unable to get the time slot . query made so far
SELECT
*,CURRENT_TIME
FROM
tbl_shift
WHERE CURRENT_TIME BETWEEN shift_start
AND shift_end
shift_id shift_name shift_start shift_end -------- ---------- ----------- -----------
1 Morning 09:00:00 13:00:00 2 Evening 13:00:00 16:15:00 3 Night 16:01:00 09:00:00Received on Fri Apr 29 2016 - 14:59:43 CEST