DATE - 'SELECT DATE' RETURNS AN INCORRECT DATE

Database
N/A

DATE - 'SELECT DATE' RETURNS AN INCORRECT DATE

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.... 

2 REPLIES

Re: DATE - 'SELECT DATE' RETURNS AN INCORRECT DATE

SELECT DATE returns the current date from the database/OS. I guess your VM date/time is not up-to-date...

N/A

Re: DATE - 'SELECT DATE' RETURNS AN INCORRECT DATE

thank Johannes... resetting the linux date and time completed my fix.  Thanks again for your advice.