Interval conversion 1

[skicamel]

I've got a number of tables containing data that comes from outside sources. I'd like to create a unifying view of the key information. The issue is session time. Most of the tables have this information stored in seconds. Some only contain the start & end dates. I can get the session time by substracting the start date from the end date, but the result is an interval type.

Any ideas how to convert an interval into seconds, or the other way around?

Any help would be appreciated. Thanks, all!

Dan

 

[skicamel]

Good Lord. I've spent two days on this, and figure out one way minutes after posting here.

cast((timeused ||' seconds') as interval)

I'd still like to hear if anyone knows of any straightforward ways to go from interval to seconds.

Thanks again, folks.

Dan

 

[ceco]

select extract (epoch from interval '1 hour 2 minutes 3 seconds');

 

[skicamel]

I could swear that section in the documentation was not there yesterday. *cough* Thanks a million.