Change teradata session date format to dd-mm-yyyy

Database

Change teradata session date format to dd-mm-yyyy

Hi folks,

I am new to teradata and facing some issues in the date format being passed from reports.

Below is the explanation of the issue.

The date format which is passed to the teradata database is 'DD/MM/YYYY'.  I think teradata default date format is 'YYYY-MM-DD'. Please correct me if I am wrong.

The queries are failing with "numeric or character conversion error".  Is there any command similar to Oracle's "ALTER SESSION" command to change the date format at session level?

Please shed some light.