Postgres Pro
Downloads
Home   >   mailing lists

RE: Timezone conversion - Mailing list pgsql-sql

From Francis Solomon
Subject RE: Timezone conversion
Date
Msg-id NFBBINJOCMGEIGPCPJBIAEIACEAA.francis@stellison.co.uk
Whole thread Raw
In response to Re: Timezone conversion  (Cedar Cox <cedarc@visionforisrael.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Cedar Cox
Date:
Subject: Re: Timezone conversion
Next
From: "J.Fernando Moyano"
Date:
Subject: Table corrupted and data lost (second time in one month!!)