Re: DateTime function

Posted in 2004

Alain Pelletier — Mon, 11 Oct 2004 12:58:37 +0200 — source: Usenet: comp.databases.informix

Hi, You can try select * from table wher col = today -4 "Jay" <jlee00_99@yahoo.com> a 'crit dans le message de news: 3ea71bf0.0410081342.2137e545@posting.google.com... > Need help with creating a query that fetches data from the previous > day. For example, I need to see all of yesterdays data from a table.