Unparsable Date for Java

luckiejacky

java.text.ParseException: Unparseable date: "Tue Aug 27 00:00:00 CST 2013"

1. SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd hh:mm:ss Z yyyy");
   
2. System.out.println("Date was " + tblSalesDetail.getValueAt(i,3).toString());
   
3. sdf.setTimeZone(TimeZone.getTimeZone("Asia/Hong_Kong"));
   
4. java.util.Date result = sdf.parse(tblSalesDetail.getValueAt(i,3).toString().trim()); <<<<<< Here
   
5. java.sql.Date sqlDate = new java.sql.Date(result.getTime());

複製代碼

Any ideas why?
Hunting for solutions for hours...

update: solved by using joda time


THX

snoopy11hk

java.text.ParseException: Unparseable date: "Tue Aug 27 00:00:00 CST 2013"Any ideas why?
Hunting for ...
luckiejacky 發表於 2013-8-25 17:03

z        Time zone        General time zone        Pacific Standard Time; PST; GMT-08:00
Z        Time zone        RFC 822 time zone        -0800

H        Hour in day (0-23)        Number        0
h        Hour in am/pm (1-12)        Number        12

quote from http://docs.oracle.com/javase/1. ... ateFormat.html#text

luckiejacky

z        Time zone        General time zone        Pacific Standard Time; PST; GMT-08:00
Z        Time zone        RFC 822 time zone ...
snoopy11hk 發表於 2013-8-25 17:24

Thanks snoopy
I was doing

1. DateTime dt = new DateTime(tblSalesDetail.getValueAt(i,3));
   
2. java.sql.Date result = new java.sql.Date(dt.toDate().getTime());

複製代碼

Then it was it.
Jack