Calculating elapsed time (in minutes) from a TIMESTAMP field in a table
738519Dec 2 2009 — edited Dec 2 2009I have a table of events that contains a field, CREATION_DATE, that is defined as NOT NULL TIMESTAMP(6), and the value is normally in the format 'DD-MON-YYYY HH:MM:SS.FFFFFF xM'. I want to SELECT only those rows where the elapsed time between the CREATION_DATE and the local time (US/EASTERN) is greater than 15 minutes. And, I'd like the output to show the values for the elapsed time in days, hours, minutes, and seconds.
Edited by: user12301147 on Dec 2, 2009 9:16 AM