I'm running an old version -Teradata 13.0 under VMWare - Linux. I've had the issue of SELECT DATE; returning an incorrect date. I'm now attempting to correct this problem.
I did this:
copied the Linux dipcal.bteq script to a Windows file
removed unwanted processes e.g. creating user SYS_CALENDAR since it existed and the modifying of PERM, SPOOL space for it
ran the BTEQ script on Windows as user DBC
The script ran OK, added 73414 rows to caldates.
Recycled VMWare to force a recycle of Teradata.
Now 'SELECT DATE;' still returns an incorrect date. So I'm missing something....