billyhafiz billyhafiz - 1 year ago 87
SQL Question

How to get the time elapsed in seconds between two timestamps in dql?

I'm using Symfony and Doctrine. I'd like to get the time elapsed between two timestamps. Here is a portion of my query (both and are type: timestamp):

$qb->select(' - AS elapsed_time');

This gives a numerical result, but I can't tell what the units are. 9 seconds gave me 49, and 60 seconds gave me 99; I can't make sense of that.

I tried this too:

$qb->select('DATE_DIFF(, AS elapsed_time');

This works, but gives the result in days. I really need minutes or seconds.

Answer Source

Use UNIX_TIMESTAMP instead. try this:

$qb->select('(UNIX_TIMESTAMP( - UNIX_TIMESTAMP( AS elapsed_time');
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download