DateTime function

Posted in 2004

Jay — 8 Oct 2004 14:42:45 -0700 — source: Usenet: comp.databases.informix

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.

↪ replying to Jay

Thomas Ronayne — Fri, 08 Oct 2004 22:42:08 GMT — source: Usenet: comp.databases.informix

If you have a date column in the table, just select blah from blah where dat_col = today - 1. Jay wrote: >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. > >