How can I find the duration of time in UNIX format between two dates in TIMESTAMP format?

Question

In Oracle, how can I find find the duration of time in UNIX format between two dates in TIMESTAMP format?

START_DATE                END_DATE                   DURATION
    "2014-08-07 10:02:39.0",  "2014-08-07 10:07:08.0"    ???UNIX FORMAT

This should be helpful: http://stackoverflow.com/questions/11617962/ — scragar, Aug 19 '14 at 15:11
Since Unix timestamps are just seconds since the epoch, duration is the difference in seconds. — Barmar, Aug 19 '14 at 15:13

score 0 · Accepted Answer · answered Aug 19 '14 at 15:12

You would do the following in PHP.

$start_date = strtotime("2014-08-07 10:02:39.0");
$end_date = strtotime("2014-08-07 10:07:08.0");

$duration = $end_date - $start_date;

Unix "format" or Unix Timestamp is all the seconds leading from 1970-01-01, till the date it's pointing at. So all the seconds from 1970-01-01 to 2014-08-07 10:02:39.0 for e.g.;

strtotime(); is a PHP Function

That converts "virtually" any given string representation of a date, into a Unix Timestamp.

After you've converted your dates into Unix Timestamps and subtracted them accordingly, what you have left with are the seconds that have passed between 2014-08-07 10:02:39.0 and 2014-08-07 10:07:08.0

Hope that helps.

I know, but I have no way to use PHP – Ivan Smorodin Aug 19 '14 at 15:23 — Ivan Smorodin, Aug 19 '14 at 15:23
Then howcome you use the PHP tag ? – Zander Rootman Aug 19 '14 at 15:28 — Zander Rootman, Aug 19 '14 at 15:28

How can I find the duration of time in UNIX format between two dates in TIMESTAMP format?

1 Answers1