Postgres Pro
Downloads
Home   >   mailing lists

Thread: help.

help.

From
Alexandr Listopad
Date:
hello!

How can I get an hour from decremented date (field)? Something like this
(don't work):
   SELECT date_part('hour',('now' - 5)::datetime); 

Thanks.

Regards, Listopad Alexandr (laa@zgia.zp.ua), LAA7-RIPE ZGIA, Zaporozhye, Ukraine.  http://www.zgia.zp.ua.