Convert char to date - Hive

Question

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 result is this:

The data in the columns:

Thank you!

Answer 1

cast( 
    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)
  as timestamp)