Oninit cdi / Archive
Talk to an expert →

Re: DBINFO parameter values

Posted in 2006

Topics: Stored Procedures & SPL, Data Types & Schema Design, Versions, Editions & End-of-Life

Neil Truby — — source: Usenet: comp.databases.informix

"Doug Lawry" <lawry@nildram.co.uk> wrote in message news:dq2jg6$sce$1@nntp0.reith.bbc.co.uk... > From classics@iiug.org "convert integer representation of datetime": > > Mladen Jova.... said: >> >> On 01/09/2006 11:01 PM, Henry Wang .... wrote: >>> >>> Is there any function to convert an integer value representing the >>> datetime since 1970/1/1 to a DATETIME data type in stored procedure. >>> I'm running IDS 10.00.UC3X9 on Linux. >> >> DBINFO('utc_to_datetime', <UTC_time>)>> >> where <UTC_time> is UTC time value >> or integer column name with UTC time value. > > Top marks! This also works on 9.4, despite not being in the InfoCenter or > PDFs. How many other undocumented DBINFO parameter values are there? RTFM? :-))

↪ replying to Neil Truby
Doug Lawry — — source: Usenet: comp.databases.informix

"Neil Truby" <neil.truby@ardenta.com> wrote in message news:42k33kF1i8qqpU2@individual.net... > > "Doug Lawry" <lawry@nildram.co.uk> wrote in message > news:dq2jg6$sce$1@nntp0.reith.bbc.co.uk... >> From classics@iiug.org "convert integer representation of datetime": >> >> Mladen Jova.... said: >>> >>> On 01/09/2006 11:01 PM, Henry Wang .... wrote: >>>> >>>> Is there any function to convert an integer value representing the >>>> datetime since 1970/1/1 to a DATETIME data type in stored procedure. >>>> I'm running IDS 10.00.UC3X9 on Linux. >>> >>> DBINFO('utc_to_datetime', <UTC_time>)>>> >>> where <UTC_time> is UTC time value >>> or integer column name with UTC time value. >> >> Top marks! This also works on 9.4, despite not being in the InfoCenter or >> PDFs. How many other undocumented DBINFO parameter values are there? > > RTFM? :-)) Which FM? It's not in it.

↪ replying to Doug Lawry
Neil Truby — — source: Usenet: comp.databases.informix

"Doug Lawry" <lawry@nildram.co.uk> wrote in message news:dq2lc0$t3q$1@nntp0.reith.bbc.co.uk... > "Neil Truby" <neil.truby@ardenta.com> wrote in message > news:42k33kF1i8qqpU2@individual.net... >> >> "Doug Lawry" <lawry@nildram.co.uk> wrote in message >> news:dq2jg6$sce$1@nntp0.reith.bbc.co.uk... >>> From classics@iiug.org "convert integer representation of datetime": >>> >>> Mladen Jova.... said: >>>> >>>> On 01/09/2006 11:01 PM, Henry Wang .... wrote: >>>>> >>>>> Is there any function to convert an integer value representing the >>>>> datetime since 1970/1/1 to a DATETIME data type in stored procedure. >>>>> I'm running IDS 10.00.UC3X9 on Linux. >>>> >>>> DBINFO('utc_to_datetime', <UTC_time>)>>>> >>>> where <UTC_time> is UTC time value >>>> or integer column name with UTC time value. >>> >>> Top marks! This also works on 9.4, despite not being in the InfoCenter >>> or >>> PDFs. How many other undocumented DBINFO parameter values are there? >> >> RTFM? :-)) > > Which FM? It's not in it. It was a joke :-(

Glossary