Re: Help! SQL example needed for date comparison!

ah262_at_detroit.freenet.org wrote:
>
> I am in urgent need of some SQL sample code that takes a database
> DATETIME formatted field and compares it to the system date (minus one
> day) for equality. I am, in effect, attempting to pull the records from
> a table dated 1 day previous from the current system date. Sounds
> simple, eh? I've looked at using the various date functions that Informix
> provides, but each one is very specialized in the resulting value it
> produces.

I do not understand:
 select * from table

        where table.datecolumn=today-1

does not work ?

Michal

-- 
--------------------------------------------------------------
Michal Hajek                   mailto:hajek_at_nspuh.cz
Sprava NIS                       http://www.nspuh.cz
NsP Uherske Hradiste          phone : voice +420 0632 529 204
Purkynova 365                         fax   +420 0632 551 014
686 68 Uherske Hradiste  Czech Republic
--------------------------------------------------------------