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

[Wei Weng]

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 checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html