Is there any readily available DateDiff function in Oracle, which is available in SQL server? My main intension is when I pass the parameters as
DateDiff(ss, current_timestamp,lastacc_datetime), it should return the value in no of seconds, same as for mi and hh.
If any one already has this kind of function, Can you please share with this forum? Or can you suggest me the logic in PL/SQL.