DateTime function
This is a discussion on DateTime function within the Informix forums, part of the Database Server Software category; --> Need help with creating a query that fetches data from the previous day. For example, I need to see ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 07:51 AM
| |||
| |||
 Re: DateTime function 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. > >      |
|
04-20-2008, 07:52 AM
| ||||
| ||||
| Re: DateTime function 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. |
Linear Mode
