SQL one liner for subtracting 1 from date

I got a statement like below to subtract 1 from given date using teradata. I am looking for a one line unix command to perform the same.

select 'parse_this_record', (DATE '${FILE_DATE}' - 1) (FORMAT 'YYYY-MM-DD');

Input: 2012-02-21
Expected Output: 2012-02-20

PS: One liner because I am going to have this date value assigned to a parameter in Ab Initio, where I can't execute a script at parameter level. :wall:

Thanks in adv !!!

What OS and shell are you using?

For anybody that is confused, this is an SQL statement, not a shell script statement.