public static void main(String[] args) {
String inputDate = "2024-01-25T15:35:35.7533836+08:00";
String outputFormat = "yyyy-MM-dd HH:mm:ss";
SimpleDateFormat inputDateFormat = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSSSSSXXX");
SimpleDateFormat outputDateFormat = new SimpleDateFormat(outputFormat);
try {
Date date = inputDateFormat.parse(inputDate);
System.out.println("---"+date);
String outputDate = outputDateFormat.format(date);
System.out.println(outputDate);
} catch (Exception e) {
e.printStackTrace();
}
}
to_date('"+eTime+"' ,'yyyy-mm-dd hh24:mi:ss')