Home » SQL & PL/SQL » SQL & PL/SQL » How to calculate time ????? Urgent
How to calculate time ????? Urgent [message #35998] Mon, 29 October 2001 18:44 Go to next message
Bhavesh Doshi
Messages: 2
Registered: October 2001
Junior Member
Hi,

I want to do calculation based on time.. meaning I want to add few minutes and minus few minutes to time. In my table, time is stored in numberic field and the values it contain are 800, 815, 830, 1030, 2030, ... so on... Can anyone give me some idea how to perform mathamatical calculation on this values...

Thanks in advance,

With regards,

Bhavesh

----------------------------------------------------------------------
Re: How to calculate time ????? Urgent [message #36004 is a reply to message #35998] Mon, 29 October 2001 21:38 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
if you are storing the time in seconds then
convert it into minutes and do the calculation
simple .
if you have to add 5 min
select (800/60)+ 5 from dual ;

----------------------------------------------------------------------
Previous Topic: How can I to made the records in one of my tables doubled every 5 minutes with a trigger?
Next Topic: Re: Reposting: URGENT : Help needed for Stored procedures
Goto Forum:
  


Current Time: Thu Mar 28 14:49:48 CDT 2024