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))
CodePudding user response：
Yes. You are looking for date_diff:
select date_diff('hour', now(), now() interval '1' hour)
Output:
| _col0 |
|---|
| 1 |