Vladimir,
Found this on the net (can't recall where though) for touching a file with
yesterdays date.
touch `TZ=GB+24 date +%m%d%H%M%y` filename
You'd need to change the GB to what is appropiate for you and change the
format variables to the format you wish
eg
echo `TZ=GB+24 date +%y%m%d`
Hi Vladimir
date --date '1 day ago'
Works on my O/S (RedHat Linux) - your O/S may not support this.
Regards
Dale
-
DataBee: Create referentially correct small versions of large Oracle
databases for development and test. http://www.DataBee.com
--
Please see the official ORACLE-L