How to Change Session Date in Teradata

DIAGNOSTIC "setcurrentdate=1120604" ON FOR SESSION;

Where the date used in the DIAGNOSTIC statement = required date - 19000000.e.g. June 4th 2012 = 20120604 - 19000000 = 1120604.

Select current_date;

Current Date

---------------------------

2012-06-04