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

Comments