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

From: Achilleus Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
To: Dinesh Pandey <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 14:39:19
Message-ID: Pine.LNX.4.44.0504181737300.18539-100000@matrix.gatewaynet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

O Dinesh Pandey έγραψε στις Apr 18, 2005 :

>
>
> How to add 1 hour in a date or time stamp?

# SELECT now() + '1 hour'::interval;

>
> Regards
> Dinesh Pandey
>
>
> ----------------------------------------------------------------------------
> ------
>
>
>
>
>
>

--
-Achilleus

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2005-04-18 14:57:23 Re: ADO and PostgreSQL functions
Previous Message Larry Rosenman 2005-04-18 13:53:37 Re: [SQL] How to add 1 hour in a date or time stamp?

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Eckermann 2005-04-18 14:51:10 Re: outer join in ms query
Previous Message Frank Habermann 2005-04-18 13:57:16 Re: user connection over tcp