A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Oracle : Getting One Hour Less Than Current Time
Joined: Jul 19, 2009
Jan 13, 2010 05:27:34
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
Roll with punchers, there is always tomorrow.
Techie Blog --
Joined: Mar 22, 2005
Jan 13, 2010 05:32:30
What does this have to do with Oracle? And what kind of code -used under which circumstances- are we talking about?
Ping & DNS, my free Android app for network diagnostics
Joined: Sep 01, 2005
Jan 13, 2010 07:18:11
select (sysdate-(1/24)) as mytime from dual
This will help.
It is sorta covered in the
JavaRanch Style Guide
subject: Oracle : Getting One Hour Less Than Current Time
WebSphere Restart Problem
application page shows blanks upgrading from Tomcat5.5 to tomcat 6
Weblogic start up slow problem
problem while inserting date field in oracle data base
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2013