由于您以字符串的形式开始时间戳，因此可以使用regexp_extract从字符串中提取每个组件。

select str_timestamp
, regexp_extract(str_timestamp, '(\\d{4})-(\\d{2})-(\\d{2}) (\\d{2}:\\d{2})', 0) as full_match
, regexp_extract(str_timestamp, '(\\d{4})-(\\d{2})-(\\d{2}) (\\d{2}:\\d{2})', 1) as year_extract
, regexp_extract(str_timestamp, '(\\d{4})-(\\d{2})-(\\d{2}) (\\d{2}:\\d{2})', 2) as month_extract
, regexp_extract(str_timestamp, '(\\d{4})-(\\d{2})-(\\d{2}) (\\d{2}:\\d{2})', 3) as day_extract
, regexp_extract(str_timestamp, '(\\d{4})-(\\d{2})-(\\d{2}) (\\d{2}:\\d{2})', 4) as time_extract
from times

您的另一个选择是像您一样提取小时和分钟，然后转换为string、lpad和concat。..

select concat_ws(':', lpad(cast(hour(record_created_timestamp) as string), 2, "0"), lpad(cast(minute(record_created_timestamp) as string), 2, "0"))