Re: DateTime function

Posted in 2004

Obnoxio The Chav — Sat, 9 Oct 2004 00:26:09 +0100 (BST) — source: Usenet: comp.databases.informix

Jay said: > 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. SELECT * FROM TABLE WHERE record_date_field = TODAY - 1; -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco sending to informix-list