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?
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?