Re: interval manipulation

Depending on versions - you can use a 'cast'... select somecol::interval(9) second to second from ... I tested with : select (current-today)::interval second(9) to second from systables where tabid=1 which gives the number of seconds since midnight... On Thursday 07 May 2009 11:56:38 Floyd Wellershaus wrote: > I can't find this anywhere, and nothing I am doing seems to work. > Is there a way to convert an interval day to second into only seconds so I > can do math on the number of seconds ? So if I select an interval from a > table whose value is 0 00:04:44, my result would be 284 ( seconds ). > > Thanks ! > Floyd -- Mike Aubury http://www.aubit.com/ Aubit Computing Ltd is registered in England and Wales, Number: 3112827 Registered Address : Clayton House,59 Piccadilly,Manchester,M1 2AQ