>> I have a possibly stupid question- I'm doing some time calculations yielding
>> intervals, and for my purposes I need to convert the interval(say, "1 day 8
>> hours") into (floating point) hours. While there's a plethora of handy
>> date_extract functionality and the like, I need a conversion.
>>
>> Any suggestions on how to accompish this? Simpler the better, of course.
>
> extract(epoch from some_interval)/3600
[slaps head] I swear, I studied the date/time sections of the manual for quite
some time...really...Siiiigh :-)
Thanks Tomasz!
Brett
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
