help.

From: Alexandr Listopad <laa(at)zgia(dot)zp(dot)ua>
To: pgsql-sql(at)postgresql(dot)org
Subject: help.
Date: 2000-01-12 13:44:32
Message-ID: Pine.BSF.4.10.10001121537270.92933-100000@Eagle.ZGIA.zp.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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(at)zgia(dot)zp(dot)ua), LAA7-RIPE
ZGIA, Zaporozhye, Ukraine.
http://www.zgia.zp.ua.

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Lockhart 2000-01-12 16:26:05 Re: [HACKERS] Re: [SQL] createdb -D xxxx not working
Previous Message admin 2000-01-12 12:12:07 stats on select