SELECT
'D' || A.ZARF_ECARS_1 || A.legacy_branch_rented as Transmittal_Number,
A.ADDRESS1 as Address,
A.CITY as CITY1,
A.STATE as STATE1,
A.POSTAL as ZIP,
A.ITEM as Debtor_Reference,

cast(A.due_DT as date format 'MM/DD/YYYY')  as DueDt,

A.BAL_AMT as Amount_Due,

Hi,
I'm new to teradta and when I'm running the following SQL:

SELECT 

cast(CALENDAR_DATE as date format 'YYYY-MM-DD')    -  INTERVAL '1' YEAR

FROM SYS_CALENDAR.CALENDAR

and get error 2666. Invalid dates supplied for CALDATE.

I have timestamp values in Varchar field. Trying to populate this data in a table where field types are properly defined, and I am unable to push data from table a (timestamp is in varchar) to table b (where I want the date to be in timestamp field). Getting error message 2666. How can I find out fields with bad dates only?