Conversations between integer and interval second (5) to second

Hello! How can I do subj ? -- Regards, Alex Antropoff

Hallo, your request was a little bit too short to understand clearly. Do you want to select some data with some integer value equal to an interval value ? If so, here is a possible solution select * from your_table where interval(00000) second(5) to second + your_integer units second = your_interval Hope this helps, if not: please specify your request more accurately ! Christian Brauer

Alex Antropoff wrote: > > Hello! > How can I do subj ? Perform the "Leffler Interval Conversion Manuever". First convert the Interval to a string containing the number of seconds by simply assigning the interval to a char(6) or longer variable then convert the numberic string to an integer by simply assigning the char variable to an integer variable. Art S. Kagel Aside: There, Jonathan, now I'm not the only one with some Informix trick named after me!

In article <37D7F4D0.FFF4B223@bloomberg.net>, Art S. Kagel <kagel@bloomberg.net> writes >Alex Antropoff wrote: >> >> Hello! >> How can I do subj ? > >Perform the "Leffler Interval Conversion Manuever". First convert the >Interval to a string containing the number of seconds by simply assigning >the interval to a char(6) or longer variable then convert the numberic >string to an integer by simply assigning the char variable to an integer >variable. > >Art S. Kagel > >Aside: >There, Jonathan, now I'm not the only one with some Informix trick named after >me! How does that help me do a Cla-vid-ian Starburst in a shuttle? Or the Picard Manoeuvre? -- David Williams