Getting TIME ELAPSED on date
Posted: January 16, 2012 Filed under: Oracle Leave a comment »select created,updated,
trunc((86400*(updated-created ))/60)
from MYTABLE where and trunc((86400*(updated-created ))/60)>10
select created,updated,
trunc((86400*(updated-created ))/60)
from MYTABLE where and trunc((86400*(updated-created ))/60)>10