"newbie" ... variable date in query

[MizzGail]

I am using informix with BaanIV.
I know how to do simple queries.
I need to pull the data from a table based on date. I know how to do this hard coded, but I need to be able to run this query from our crontab on unix and look for all changes for today and yesterday.

How do I get this query to pickup todays date and yesterdays from the system?

select * from price-table
where effdate between yesterday and today

 

[vpshriyan]

Hi,

In the simplest form; you may ask the database server itself to figure out the dates. e.g.

select * from price-table
where effdate between today-1 and today

Regards
Shriyan

 

[MizzGail]

Great! thank you so much!!