Oracle : Getting One Hour Less Than Current Time

Ranch Hand

Posts: 110

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi,

Can someone help me out how take one hour less than the current time, dynamically.
For example-- if current time is 13-Jan-2010 17:52:42, then i need 13-Jan-2010 16:52:42.

Thanks,
Tanzy.

Roll with punchers, there is always tomorrow.
Techie Blog -- http://jtanzy.blogspot.com/

Ulf Dittmer

Rancher

Posts: 43081

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

What does this have to do with Oracle? And what kind of code -used under which circumstances- are we talking about?

Fatih Keles

Ranch Hand

Posts: 182

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

This will help.

Regards,

Fatih.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.