Thursday, 8 August 2013

How to change a 'date' in Char format to date format in teradata SQL?

How to change a 'date' in Char format to date format in teradata SQL?

I have a column date like date CHAR(7) CHARACTER SET LATIN NOT
CASESPECIFIC, where i have some values like 2010-12, 2011-10, etc. i want
to change these into the date format yyyy/mm . How do i do it? Thanks

No comments:

Post a Comment