Hi
It is possible pass to one program a parameter YESTERDAY DATE , i mean the current date less one day (sysdate -1) ?

Perderabo wrote a cool date script that will do what you ask and more! Click Here To Get the Script. Use the date_calc script to calculate the date you need then pass it as a parameter to your script. Good Luck.

I needed that functionality once too, I went about it by appending the current date to a file every day at 23:59 in cron... then refrencing that file whenever I needed to write a script to get things for yesterday... or last 5 days and so on and so forth.

yesterdaysdate=`head -1 $datefile`
past5days=`head -5 $datefile`

Interesting work-around; it sounds like you'd end up with a large file in a short amount of time though ... Perderabo's script is worth taking a look at. It has a ton of functionality to it.

Here is how I get yesterdays date


DATE_STAMP=`TZ=CST+24 date +%y%m%d`

Try the following command at your unix prompt:

perl -e 'print localtime(time() - 86400) . "\n" '

If your unix machine has Perl installed, then it will work.

This works but can you please tell for what we use "TZ" and "CST"???