Re: Anywhere to Add an hours to sysdate ?

select to_char( sysdate + 1/24 , 'dd-mm-yyyy hh24:mi' ) from dual;

or

l_date := sysdate + 1/24;

etc etc

Cheers

Steve Bright

steve.bright_at_capgemini.co.uk

yew.poo.choon_at_mbf.com.my wrote in message <7oudhn$voh$1_at_nnrp1.deja.com>...
>Hi,
> Does anybody know how to add hour to a date ?
> I need to add an hour to the current sysdate is there
> a way to do it just through PL/SQL Plus.
> Hope someone can help. I really need it.
>
> if possible please email me to yewpc_at_yahoo.com as well
> Thank you first.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Aug 12 1999 - 07:44:48 CDT