Home » SQL & PL/SQL » SQL & PL/SQL » dates function
dates function [message #35819] Wed, 17 October 2001 07:50 Go to next message
V
Messages: 12
Registered: October 2001
Junior Member
how to take the difference of minutes from

----------------------------------------------------------------------

Report message to a moderator

Re: dates function [message #35825 is a reply to message #35819] Wed, 17 October 2001 09:29 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
there is no direct function available to get result in minutes. what you have to do is get difference of 2 dates which will be in days and do some math.

(sysdate+1)-(sysdate) gives 1
1*24*60 gives minutes.

HTH
SURESH

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Re: Table Lock
Next Topic: Oracle Stored Procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 23:22:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.