0 - 1 of 1 tags for teradata.net

 

CREATE VOLATILE TABLE temp(cola VARCHAR(20),colb VARCHAR(20),dat1 DATE FORMAT 'ddmmyyyy',

dat2 DATE FORMAT 'ddmmyyyy')

 ON COMMIT PRESERVE ROWS;

 

When i tried inserting using the ODBC connection like this

 

INSERT INTO temp VALUES('a','b','01012000','05012000');