This content has been marked as final. Show 3 replies
There are several ways to calculate time differences.
for a 'classic example'.
Other functions that you can use are EXTRACT and /or NUMTODSINTERVAL.
Search this forum for many examples.
Too bad you did not post create table and insert into statement, since now we do not know the datatype of your column.
Suggest to read and search the following links, to find more explanations and examples:
http://www.oracle.com/pls/db112/homepage (search box = at upper left corner)