Exception: Unparseable date for different languages

[Steve Jiang]

I am using the following code to convert the date for different language, but it works for English and Japanse, but failed for Chinese and Korea with the error like "java.text.ParseException: Unparseable date: "2009-08-14 下午 10:00:01""


What will be better way to handle all kinds of language for Date format?

        SimpleDateFormat sf = (SimpleDateFormat) DateFormat.getDateTimeInstance(DateFormat.SHORT,
                                                                                 DateFormat.MEDIUM,
                                                                                 request.getLocale());

            String execDate = (String)list.get(DATE);   // own function to get Date , for CHinese the date format will be like 2009-08-14 下午 10:00:01
    
            Timestamp sDate = null;
            java.util.Date dt =null;
            if (execDate!=null)
            {
                dt = sf.parse(execDate);   //here throw exception for Chinese and Korea, but works for English and Japanese
                sDate = new Timestamp(dt.getTime());
            }

[Mathew Lee]

i am not sure if you can do all kinds of languages

[Steve Jiang]

The code is using as ORADateFormat to get the pattern , looks like it works for English, Japanese.

I have n't find the way to convert the ORADateformat pattern with simpledateformat, but I am guess it could have some way?

        String pattern = OraDateFormat.getDefaultDateTimeFormatPattern(OraDateFormat.SHORT, request.getLocale());  //used for date pattern for execDate 

        SimpleDateFormat sf = (SimpleDateFormat) DateFormat.getDateTimeInstance(DateFormat.SHORT,  
                                                                                 DateFormat.MEDIUM,  
                                                                                 request.getLocale());  
  
            String execDate = (String)list.get(DATE);   // Date format with OraDateFormat patter as first line , for CHinese the date format will be like 2009-08-14 下午 10:00:01  
      
            Timestamp sDate = null;  
            java.util.Date dt =null;  
            if (execDate!=null)  
            {  
                dt = sf.parse(execDate);   //here throw exception for Chinese and Korea, but works for English and Japanese  
                sDate = new Timestamp(dt.getTime());  
            }