jirinej(at)volny(dot)cz (JN) wrote in message news:<7e29a94a(dot)0410220404(dot)314f4308(at)posting(dot)google(dot)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'))