pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Francis Solomon <francis@stellison.co.uk>
To: Cedar Cox <cedarc@visionforisrael.com>
Cc: pgsql-sql@postgresql.org
Subject: RE: Timezone conversion
Date: Tue, 24 Apr 2001 12:54:33 +0100
Message-ID: <NFBBINJOCMGEIGPCPJBIAEIACEAA.francis@stellison.co.uk> (raw)
In-Reply-To: <Pine.LNX.4.21.0104241304580.19858-100000@nanu.visionforisrael.com>

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




view thread (7+ messages)  latest in thread

Message-ID: <NFBBINJOCMGEIGPCPJBIAEIACEAA.francis@stellison.co.uk>
Permalink:  ../NFBBINJOCMGEIGPCPJBIAEIACEAA.francis@stellison.co.uk/
Also on:    postgresql.org/message-id/NFBBINJOCMGEIGPCPJBIAEIACEAA.francis@stellison.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: francis@stellison.co.uk, cedarc@visionforisrael.com
  Subject: RE: Timezone conversion
  In-Reply-To: <NFBBINJOCMGEIGPCPJBIAEIACEAA.francis@stellison.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox