Conversations between integer and interval second (5) to second
Alex Antropoff asked how to convert between an integer and an INTERVAL SECOND(5) TO SECOND. Christian Brauer gave a SELECT using interval(00000) second(5) to second plus the integer UNITS SECOND. Art S. Kagel recommended assigning the interval to a char(6) or longer variable, then that to an integer. David Williams replied jokingly. Answered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
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