数据库是hive,不支持这个日期时间格式转化吗
SQL语句:
SELECT br_acc_cod as long_col_0, br_acc_des as long_col_1, account_id as long_col_2, is_post as long_col_3, ats_received_amount as long_col_4
, ats_pay_amount as long_col_5, ats_balance as long_col_6, sap_dr_amount as long_col_7, sap_cr_amount as long_col_8, sap_balance as long_col_9
, receives_diff as long_col_10, pay_diff as long_col_11, balance_diff as long_col_12, insert_time as ETL_TIME, part_dt as PART_DT
, from_unixtime(unix_timestamp(CONCAT(substring(part_dt, 1, int(4)), '-', substring(part_dt, int(5), int(2)), '-', CASE
WHEN length(part_dt) > 2 THEN substring(part_dt, length(part_dt) - int(2) + 1)
ELSE part_dt
END), 'yyyy-MM-dd'), 'yyyy-MM-dd HH:mm:ss') as long_col_13
FROM bisi_dm.dmk_fin_accrual_difference_ats_d