转换时间
SELECT to_date('03/12/2024 10:10:28','MM/dd/yyyy hh:mi:ss') as TRANSACTION_DATE from dual --转换成时间日期
SELECT to_char(to_date('03/12/2024 10:10:28','MM/dd/yyyy hh:mi:ss'),'yyyy/mm/dd hh:mi:ss') as TRANSACTION_DATE from dual --转换成文本日期
SELECT max(to_char(to_date('03/12/2024 10:10:28','MM/dd/yyyy hh:mi:ss'),'yyyy/mm/dd hh:mi:ss')) as TRANSACTION_DATE from dual