Postgres Pro
Downloads
Home   >   mailing lists

help. - Mailing list pgsql-sql

From Alexandr Listopad
Subject help.
Date
Msg-id Pine.BSF.4.10.10001121537270.92933-100000@Eagle.ZGIA.zp.ua
Whole thread Raw
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: "Albert Loo"
Date:
Subject: Re: [SQL] query to do a backward 'skip' ...thanks, it's working.
Next
From: admin
Date:
Subject: stats on select