Обсуждение: How to add 1 hour in a date or time stamp?

Поиск
Список
Период
Сортировка

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

От
"Dinesh Pandey"
Дата:

 

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

Regards
Dinesh Pandey


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

 

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

От
"Sean Davis"
Дата:
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: [SQL] How to add 1 hour in a date or time stamp?

От
Larry Rosenman
Дата:
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: [SQL] How to add 1 hour in a date or time stamp?

От
Achilleus Mantzios
Дата:
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