Query between two dates and two times

Question

I'm trying to query a specific range of time, Eg.:

SELECT * FROM production 
WHERE
production.begin BETWEEN '2017/05/15' AND '2017/05/16'  
AND production.begin BETWEEN '00:15' AND '15:00'

The expected result would be productions that began at '2017/05/15 00:15' to '2017/05/15 15:00' and that began at '2017/05/16 00:15' until '2017/05/16 15:00', excluding lines from '2017/05/15 15:01' until '2017/05/16 00:14'.

Thanks!

What data type is the column `begin`? – Aug 21 '17 at 18:02 — , Aug 21 '17 at 18:02
timestamp without time zone – jlwollinger Aug 21 '17 at 18:03 — jlwollinger, Aug 21 '17 at 18:03

score 3 · Accepted Answer · answered Aug 21 '17 at 19:07

3

select * 
from production 
where
    production.begin::date between '2017/05/15' and '2017/05/16'  
    and 
    production.begin::time between '00:15' and '15:00'

answered Aug 21 '17 at 19:07

Clodoaldo Neto

118,695
26
233
260

Query between two dates and two times

1 Answers1