Forum OpenACS Q&A: Response to Best way to select between hours?

Posted by Michael A. Cleverly on
The easiest way to get all the values within a given range of dates (or integers, etc.) would be to use select ... where column between 'x' and 'y'.

Taking your query above, something like:

select distinct creation_user
from chat_msgs
where to_char(creation_date, 'HH24:MI:SS') between '11:30:00' and '14:30:00'