From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
---|---|
To: | JN <jirinej(at)volny(dot)cz> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: now() + integer, not rounded to whole day |
Date: | 2004-10-25 16:32:50 |
Message-ID: | 20041025163250.GA11043@wolff.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Mon, Oct 25, 2004 at 02:27:01 -0700,
JN <jirinej(at)volny(dot)cz> wrote:
> 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'))
You probably wanted to do something like: now() + '1 hour'::interval
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2004-10-25 17:19:02 | Re: "copy from" in "create function" |
Previous Message | Mike Rylander | 2004-10-25 13:05:39 | Re: sql |