Re: system date/time

Hi, If you run the statement: SELECT CURRENT from systables where tabid = 1 ;it will returns the current date and time, as everybody said to you. But, if the "fraction" of seconds allways becomes 0 , see your onconfig file the parameter: USEOSTIMEIf it is 0 (zero), the IDS don't 'ask' to the operational system the right time. IF it is 1 every time when it is called, the IDS makes a 'call' to the operational system to get it. Is because that the performance can goes down. Best regards .... R. Ferronato kstahl <ktsahl@yahoo.com> wrote in message news:<OrWdnVhmVvCIuJLd4p2dnA@comcast.com>... > How would I select just the system date/time from an Informix > datebase. > > For example, in Oracle it would be "select sysdate from dual". I > just need the Informix equivalent. > > TIA

Ferronato wrote: > Hi, > > If you run the statement: > SELECT CURRENT from systables where tabid = 1 ;> it will returns the current date and time, as everybody said to you. > > But, if the "fraction" of seconds allways becomes 0 , see your > onconfig file the parameter: > USEOSTIME> If it is 0 (zero), the IDS don't 'ask' to the operational system the > right time. > IF it is 1 every time when it is called, the IDS makes a 'call' to the > operational system to get it. Is because that the performance can goes > down. > > Best regards .... R. Ferronato > > kstahl <ktsahl@yahoo.com> wrote in message news:<OrWdnVhmVvCIuJLd4p2dnA@comcast.com>... > >>How would I select just the system date/time from an Informix >>datebase. >> >>For example, in Oracle it would be "select sysdate from dual". I >>just need the Informix equivalent. >> >>TIA I only need accuracy to the second, so fractional portions of seconds won't affect what I'm doing. Ultimately I'm really only interested in detecting whether the system time in the database is in standard time or DST.