to_char_pattern=r"to_char\((.*?),\s*'YYYY-MM-DD hh24:mi:ss'"
to_char_replace=r"formatDateTime(\1,'%F %T'"
to_date_pattern=r"to_date\((.*?),\s*'.*?'"
to_date_replace=r"toDateTime(\1"
sql = re.sub(to_char_pattern, to_char_replace, sql, flags=re.IGNORECASE)
sql = re.sub(to_date_pattern, to_date_replace, sql, flags=re.IGNORECASE)
12-11
3万+
07-13
3万+
06-17
9853