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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.