DATE or is it DAY?

BIS · Mar 12, 2002

Hello,
I am extremely new to Informix, so forgive me if my question is the most stupid one you people have had for a long time.
I am looking for a way to write 'yesterday'.
Suppose I have this querry: select * from TABLE where row_date='yesterday'. How do I write 'yesterday? I have tried DAY-1, DATE-1 but that does not work. Can someody point me in the right direction?

mberni · Mar 12, 2002

Try:

select whatever
from table
where datumsfeld=today-1;

BIS · Mar 12, 2002

Superb! Thanks, that helped.

BIS · Mar 13, 2002

Is there also a similar command for 'last month' ? Something like 'thismonth-1' ?

olded · Mar 13, 2002

Bis:

Yes. Use the internal Informix month function. This command:

select * from table where month(datumsfeld) = 3

gets all data from 'table' where the 'datumsfeld' date column is march. There's also corresponding day and year functions.

Regards,

Ed
Schaefer

BIS · Mar 13, 2002

Many many thanks!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

DATE or is it DAY?

BIS

Technical User

mberni

IS-IT--Management

BIS

Technical User

BIS

Technical User

olded

Programmer

BIS

Technical User

Similar threads

Part and Inventory Search

Sponsor