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.

jirinej [at] volny.cz (JN) wrote in message news:<7e29a94a.0410220404.314f4308 [at] posting.google.com>...
> 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.

It's simpler than I thought

now() + (TO_TIMESTAMP('1970-01-01 00:01:00', 'yyyy-mm-dd HH24:MI:SS')
- TO_TIMESTAMP('1970-01-01 00:00:00', 'yyyy-mm-dd HH24:MI:SS'))

On Mon, Oct 25, 2004 at 02:27:01 -0700,
JN <jirinej [at] volny.cz> wrote:
> jirinej [at] volny.cz (JN) wrote in message news:<7e29a94a.0410220404.314f4308 [at] posting.google.com>...
> > 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.
>
> It's simpler than I thought
>
> now() + (TO_TIMESTAMP('1970-01-01 00:01:00', 'yyyy-mm-dd HH24:MI:SS')
> - TO_TIMESTAMP('1970-01-01 00:00:00', 'yyyy-mm-dd HH24:MI:SS'))

You probably wanted to do something like: now() + '1 hour'::interval

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend