Oracle : Getting One Hour Less Than Current Time

[Tanzy Akhtar]

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.

[Ulf Dittmer]

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

[Fatih Keles]

  select (sysdate-(1/24)) as mytime from dual 

This will help.

Regards,

Fatih.