ReadVitamin

Inserting current date value into Teradata table

Written by admin in Monday, July 2nd 2007 under IT

This is pretty simple, have a date column present in your table as follows.

CREATE SET VOLATILE TABLE employee, NO FALLBACK, CHECKSUM = DEFAULT,

LOG ( “emp_no” INTEGER,

“dept_no” VARCHAR (10),

“first_name” CHAR (20) CHARACTER SET LATIN NOT CASESPECIFIC,

“last_name” CHAR (20) CHARACTER SET LATIN NOT CASESPECIFIC,

“salary” INTEGER,

“start_date” DATE )PRIMARY INDEX (“emp_no”)ON COMMIT PRESERVE ROWS;

Insert a row with the following INSERT command

INSERT INTO employee VALUES (1000, 112,’Philip’,'Josheph’, 65000, date);

Do a select * from employee table and you would see the following result.

emp_no dept_no first_name last_name salary start_date

1000 112 Philip Josheph 65,000 07/02/2007

Popularity: 14% [?]

Inserting current date value into Teradata table