Home » RDBMS Server » Server Administration » Date manip
Date manip [message #375220] Tue, 07 August 2001 06:31 Go to next message
Vikram
Messages: 16
Registered: March 2000
Junior Member
How do I substract 10 mins from the sysdate and get the result.
Re: Date manip [message #375223 is a reply to message #375220] Tue, 07 August 2001 08:30 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select (sysdate-(1/(24*60))*10) from dual

Suresh
Previous Topic: Date manip
Next Topic: Re: Windows 2000 & Oracle 8i
Goto Forum:
  


Current Time: Tue Dec 24 06:30:42 CST 2024