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
- updated with new look and Ping home screen widget
Joined: Sep 01, 2005
Jan 13, 2010 07:18:11
select (sysdate-(1/24)) as mytime from dual
This will help.
I agree. Here's the link:
subject: Oracle : Getting One Hour Less Than Current Time
WebSphere Restart Problem
problem while inserting date field in oracle data base
Weblogic start up slow problem
application page shows blanks upgrading from Tomcat5.5 to tomcat 6
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014