Hi all ! I've search all the doc to find a function which would allow me to convert an interval into a number of seconds. What I get is @ 1 hour, what I would like is -3600. I'd think to something like select interval('sec', myTime) - Ingres syntax - but it doesn't work. Does somebody has an idea ? ______________ B. Carrupt