Umm.. define 'it'. (Isn't current_timestamp or now() already a
timestamp?)
select CURRENT_TIMESTAMP, CURRENT_TIMESTAMP-2*3600;
timestamp | ?column?
------------------------+------------
2001-04-24 13:06:11+03 | 1981-08-07
I also have a question.. How, for example, would I add 90 days to the
current timestamp?
Thanks,
-Cedar
On Thu, 19 Apr 2001, Grant wrote:
> Convert it to timestamp and minus TIMEZONE * 3600...
>
> On Wed, 11 Apr 2001, Roberto Mello wrote:
>
> > Hi,
> >
> > How can I do timezone conversions in PG? I looked on the docs and
> > couldn't find how. I want to find the current time in another timezone.
> >
> > Thanks,
> >
> > -Roberto
> >
> > P.S: This type of function would be excellent on the cookbook
> > (www.brasileiro.net).
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
