Hi all,
Can i get the difference between two timestamps in seconds.
If i use
t1 timestamp;
t2 timestamp;
select t1 - t2;
i get something like "10 days" or "00:10".
Can i get the number of seconds elapsed between the two timestamps.
Plz help me. I am trying the first time using the stored procedures.
TIA.
--
luv,
hari
__
/ / __ _ _ _ _ __ __ -o)
/ /__ / / / \\// //_// \\ \\/ / /\\\\ Making things happen
/____/ /_/ /_/\\/ /___/ /_/\\_\\ _\\_v-
-------------------------------------------------------------------
Midas Communications (p) Ltd,
Chennai.
Ph (O) 24512050. Extn : 321
Ph (R) 26161105.