Re: [SQL] How to add 1 hour in a date or time stamp?

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: dpandey(at)secf(dot)com
Cc: "'PostgreSQL'" <pgsql-sql(at)postgresql(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: [SQL] How to add 1 hour in a date or time stamp?
Date: 2005-04-18 13:53:37
Message-ID: 200504180853.37372.ler@lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On Monday 18 April 2005 08:38 am, Dinesh Pandey wrote:
> How to add 1 hour in a date or time stamp?
timestamp + '1 hour'::interval

is one way.

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-351-4152 E-Mail: ler(at)lerctr(dot)org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleus Mantzios 2005-04-18 14:39:19 Re: [SQL] How to add 1 hour in a date or time stamp?
Previous Message Sean Davis 2005-04-18 13:50:54 Re: [SQL] How to add 1 hour in a date or time stamp?

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Habermann 2005-04-18 13:57:16 Re: user connection over tcp
Previous Message Sean Davis 2005-04-18 13:50:54 Re: [SQL] How to add 1 hour in a date or time stamp?