Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
"Dinesh Pandey"
Date:

 

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

Regards
Dinesh Pandey


----------------------------------------------------------------------------------

 

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

From
"Sean Davis"
Date:
Dinesh,
 
The documentation is very helpful for this topic.  Typing 'add 1 hour timestamp' into the search box at:
 
 
yields the following page as the first hit:
 
 
Sean
 
----- Original Message -----
Sent: Monday, April 18, 2005 9:38 AM
Subject: [SQL] How to add 1 hour in a date or time stamp?

 

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

Regards
Dinesh Pandey


----------------------------------------------------------------------------------

 

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

From
Larry Rosenman
Date:
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@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611

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

From
Achilleus Mantzios
Date:
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