Re: value for TODAY

Hari Muthuswamy wrote: > Where does Informix gets the current date. Does it get from the > Operating System? > For example, > from DBACCESS, when I run a statement like > 'Select * from today' where does Informix get the date for > 'today' > from. > I think your syntax is a bit off here. In the example you gave, you're trying to select values from a table named "today", not get the value of this day's date. Usually the date would come from or thru the OS somehow. I suppose one could write some low-level calls directly to the hardware, but I'm not sure what one would gain from not using a function already provided by the OS. Although there IS that parameter in Online where one choses not to use the OS time - not sure what that's about. -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. Cosmo Lee Multi-User Computer Systems Brooklyn, NY email: cosmo@echonyc.com "JUST SAY 'NO' TO SPAM" * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *