I want to create a table in teradata with YYYY-MM format and give default value as '0001-01' Want to Is it possible to do both? .. but I am able to do this ..
Table test (T1 date format 'yyyy-mm' is not zero); <
Both work perfectly are doing.
Enter your SQL Request or BTEQ command: CT-T1 (X1 int, Y1 date format 'yyyy-mm' zero's default date '0001-01-01'); CT T1 (X1 int, Y1 date format 'YYY-MM' is not the default date of zero '0001-01-01'); *** The table has been created. *** Total time passed was 1 second. BTQ - Enter your SQL Request or BTE QE: these T1 (1, '2011-11'); In T1 (1, '2011-11'); *** Insert complete. One line added *** Total time passed was 1 second. BTEQ - Enter your SQL Request or BTEQ commands: these T1 (2,); In T1 (2,); *** Insert complete. One line added *** Total time passed was 1 second. BTEQ - Enter your SQL Request or BTEQ commands: from SL * T1; From SL * T1; *** The question is complete. 2 rows found 2 columns returned. *** Total time passed was 1 second. X1 y1 ----------- ------- 1 2011-11 2 0001-01
No comments:
Post a Comment