Teradata - Date format conversion from INT(yyyymmdd) type to date(mm/dd/yyyy) in Teradata SQL Assistant
10:23 21 Feb 2022

I have dates in integer format in a column. The length is 11. Example values current format integer (11) --> date format required

  • yyyymmdd --> dd/mm/yyyy
  • 20121203 --> 03/12/2012
  • 20090403 --> 03/04/2009

Can someone suggest a solution keeping in mind that the change need to reflect across the entire column in the table?

teradata teradata-sql-assistant teradatasql