RE: Timezone conversion

From: "Francis Solomon" <francis(at)stellison(dot)co(dot)uk>
To: "Cedar Cox" <cedarc(at)visionforisrael(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: RE: Timezone conversion
Date: 2001-04-24 11:54:33
Message-ID: NFBBINJOCMGEIGPCPJBIAEIACEAA.francis@stellison.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi Cedar,

Does this help?

select CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + '90 days';

timestamp | ?column?
------------------------+------------------------
2001-04-24 12:57:56+01 | 2001-07-23 12:57:56+01

>
> I also have a question.. How, for example, would I add 90 days to the
> current timestamp?
>
> Thanks,
> -Cedar

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Vasilis Samoladas 2001-04-24 13:29:51 Re: Using Random Sequence as Key
Previous Message Cedar Cox 2001-04-24 10:57:18 Re: [SQL] select ... for update in plpgsql