Home > mailing lists

now() + integer, not rounded to whole day - Mailing list pgsql-sql

From	jirinej@volny.cz (JN)
Subject	now() + integer, not rounded to whole day
Date	October 25, 2004 20:04:22
Msg-id	7e29a94a.0410220404.314f4308@posting.google.com Whole thread Raw
List	pgsql-sql

Tree view

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.

pgsql-sql by date:

From: Bricklen
Date: 25 October 2004, 20:02:20
Subject: Re: Finding duplicated values

From: "Scott Marlowe"
Date: 25 October 2004, 20:06:54
Subject: Re: [GENERAL] Log

now() + integer, not rounded to whole day - Mailing list pgsql-sql

Previous

Next