Called procedures retain the date and time formats in effect when the procedures were created. Called procedures do not reflect the dateform in effect for the session in which the procedures are called unless the date and time format is the same as the dateform in effect when the procedure was created.
See “SET SESSION DATEFORM” in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.