Re: Problem with SQL TODAY
Gordon E. Hooker wrote:
>
> 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
When was your PC booted???? I've run into the problem before with PC's
that the environment variable gets set to TODAY, but tommorrow it is
still yesterday. Could be if you reboot daily the problem goes away.
Bret.