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

[Tomasz Myrta]

Dnia 2003-12-04 19:09, Użytkownik 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])