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