Re: Anywhere to Add an hours to sysdate ?

In article <7oudhn$voh$1_at_nnrp1.deja.com>,   yew.poo.choon_at_mbf.com.my wrote:
> 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.
>

The Oracle sysdate is derived from the OS system date value. You may want to update the date on your OS if this is a permanent change you are looking for.

If you have an application that needs to read the current date/time + 1 hour, you could select the date as something like :
  to_char(sysdate+(1/24),'DD-MON-YYYY HH:MI')

You can also set a fixed date in the init.ora file for testing or development efforts - look in the Server Reference Guide for init.ora parameters available with your Oracle version.

• Lisa

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 12 1999 - 07:36:59 CDT