0
I need to concatenate two columns that are char to turn into date, but with the code below the part of the time is reset. Both columns have information and are not null or blank.
CAST(from_unixtime(unix_timestamp(CONCAT(
substr(dt_atendimento_fcdr, 1, 4), '-', substr(dt_atendimento_fcdr, 5, 2), '-', substr(dt_atendimento_fcdr, 7, 2), ' ',
substr(hr_atendimento_fcdr, 1, 2), ':', substr(hr_atendimento_fcdr, 3, 2), ':', substr(hr_atendimento_fcdr, 5, 2)), 'yyyy-MM-dd HH:mm:ss')) as timestamp)
The data in the columns:
Thank you!