Re: time interval question

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 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.postgresql.org/users-lounge/docs/faq.html

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi