[SQL] How do I convert an interval into integer?

I want to convert an interval (from substraction between two timestamps) into a integer that represents how many seconds that interval has. How do I do that? I am using postgresql 7.3.1 Thanks Wei ---(end of broadcast)--- TIP 5: Have you

Re: [SQL] How do I convert an interval into integer?

Dnia 2003-12-04 19:09, Uytkownik Wei Weng napisa: I want to convert an interval (from substraction between two timestamps) into a integer that represents how many seconds that interval has. How do I do that? select extract(epoch from your_interval); Regards, Tomasz Myrta