Re: Problem with SQL TODAY

chaiw@ibm.net (Chaiw Kok Kee) wrote: >I wonder if anybody can help me. I'm running ESQL-C on a client access >Informix On-Line 5.07 on another Unix Server. The following SQL, whether in >ESQL-C or DBACCESS returns yesterday instead of the system date. > > $select inv_date > into $jdate > where inv_date = TODAY; > I this may be a stupid question, but did you check the system date on the system machine. Maybe your clock is not set correctly. >Running Query Language using dbaccess has the same problem but running isql on >the server (where the database resides) yields the correct result. I think >there might be a problem with inet. > >I would appreciate if anybody can share there experience. > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP 25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555 Email gordonh@thehub.com.au _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ We are just two lost souls living in a fish bowl Year after year Pink Floyd