Home » SQL & PL/SQL » SQL & PL/SQL » difference between two timestamps
difference between two timestamps [message #236228] |
Wed, 09 May 2007 06:33  |
soujanya_srk
Messages: 111 Registered: November 2006 Location: HYDERABAD
|
Senior Member |
|
|
i know how to calculate time difference in seconds given
two dates, (using to_date() - to_date())
i am testing the performance of a function, and am capturing
the systimestamp in one variable(bs)
bs:=systimestamp immediately after begin
and before end, i say ls:=systimestamp
now i want a query to find out the difference between these
two variables...basically, its the difference in milliseconds
between two dates...
so that i can fetch it into another variable, and then see
how fast my function is performing
can anyone please tell me how to find out difference between
2 systimestamps?
that is difference in milliseconds
|
|
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Thu Jun 12 16:33:31 CDT 2025
|