The below gives me results like 1 00:00:00.000 However, I’d like the number of hours elapsed as a float or double.
SELECT FROM_UNIXTIME(ds2) - FROM_UNIXTIME(ds1)
Does something like the below exist?
SELECT HOURS(FROM_UNIXTIME(ds2) - FROM_UNIXTIME(ds1))
>Solution :
Yes. You are looking for date_diff:
select date_diff('hour', now(), now() + interval '1' hour)
Output:
| _col0 |
|---|
| 1 |