[GENERAL] time interval question

[Cefull Lo]

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