Re: Help! SQL example needed for date comparison!

The next statement is guaranteed to work: select * from table where trunc(date1)=trunc(date2). Trunc removes the timepart from the date. Regards Frank >On Thu, 27 Nov 1997 14:58:34 +0100, Michal Hajek <hajek@nspuh.cz> >wrote: > >>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 >>-------------------------------------------------------------- >