Re: Date math question

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Date math question
Date: 2008-11-26 18:57:07
Message-ID: 20081126185707.GA23096@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Nov 26, 2008 at 11:54:33AM -0700, Kevin Kempter wrote:
> select ts, ts + interval dursec seconds from tmp2 limit 1;
> select ts, ts + 'seconds' dursec from tmp2 limit 1;

select ts, ts + dursec * '1 second'::interval ...

depesz

--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2008-11-26 19:00:14 Re: Date math question
Previous Message Kevin Kempter 2008-11-26 18:54:33 Date math question