Hi,
Is there any easy way to convert the result of timestamp
arithmetic to a simple decimal number?
I have something like:
select current_timestamp - timein as daysat from transcations
daysat looks like:
3 days 12:00:00
I want it to look like:
3.5
I fooled around a bit to_number(text, text). It seems like
I would need something that would parse out the days and hours
or else a global formatting flag. I guess I could write my
own function, but was wondering if there's some better way.
Thanks!