SELECT data_tm FROM (select DISTINCT data_tm from dw_eco_env_qual_atm_orig_h_mon_data_hist_dtl order by data_tm desc) a
WHERE cast(data_tm as datetime) <(SELECT MAX(cast(data_tm as datetime)) FROM (select DISTINCT data_tm from dw_eco_env_qual_atm_orig_h_mon_data_hist_dtl order by data_tm desc) a)
LIMIT 1;