Hi,
You could do something along the lines of :
SELECT foo, bar FROM baz WHERE date_part('hour', foo) > 0 AND
date_part('hour', foo) < 8;
Simple, but effective. Only works for whole hours like in your example
though.
:-)
Regards and best wishes,
Justin Clift
Cefull Lo wrote:
>
> given a
given a timestamp data, e.g. 2001-08-18 06:01:23+08
How can I check that is it lie between 00:00:00 and 08:00:00 and ignore the
date?
--
content-type:kiss/hug
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgre
