Could someone share some idea on how to create a 'YEAR/MONTH' only field in a teradata table? I tried it using the option 'TEST_DT DATE FORMAT 'YYYY/MM' ', but the 'DAY' portion still gets stored as '01' by default!! -Thanks
I am not sure if you can create a date field that will have only year and month yyyy/mm. (I never did that). If you create a date field it looks for a numeric value that convers to a valid date. sorry !