Re: timestamp + 1 hour????

>>>>> "CL" == Cefull Lo <cefull_lo(at)yahoo(dot)com> writes:

CL> How to add one hour to a given timestamp??
CL> select current_tmestamp +1;
CL> will result in one day added.

select current_timestamp + '1 hour'::interval

CL> Thanks

CL> --
CL> content-type:kiss/hug

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D. Khera Communications, Inc.
Internet: khera(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/