Re: Help! SQL example needed for date comparison!

Posted in 1997

Michal Hajek — Thu, 27 Nov 1997 14:58:34 +0100 — source: Informix-list mailing list archive (1991-1998)

ah262@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@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 --------------------------------------------------------------