now() + integer, not rounded to whole day

From: jirinej(at)volny(dot)cz (JN)
To: pgsql-sql(at)postgresql(dot)org
Subject: now() + integer, not rounded to whole day
Date: 2004-10-22 12:04:18
Message-ID: 7e29a94a.0410220404.314f4308@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is it possible to add some portion of the day to now() ? I cannot
round now() to whole days like now()::date. Hours, minutes and seconds
are also important to me. This I had in Oracle, and need to convert it
:

sysdate + 1/1440

Thanks for any suggestion.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau 2004-10-22 13:38:29 Re: Functions return a select in a table, which data type I
Previous Message Christoph Haller 2004-10-22 07:49:28 Re: Finding duplicated values