Re: [SQL] now() + integer, not rounded to whole day

[JN]

[EMAIL PROTECTED] (JN) wrote in message news:<[EMAIL PROTECTED]>...
> 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', '-mm-dd HH24:MI:SS')
- TO_TIMESTAMP('1970-01-01 00:00:00', '-mm-dd HH24:MI:SS'))

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[SQL] now() + integer, not rounded to whole day

[JN]

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.

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org