select calendar_date as DATEO from sys_calendar.CALENDAR
where calendar_date between ?  and cast(? as date)+31
order by calendar_date

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.