How can I parse this String into a java.sql.Date format? (Java in General forum at Coderanch)

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

有腹肌的啄木鸟 · 使用 JdbcTemplate ...· 5 天前 ·

爱跑步的钥匙 · MybatisPlus学习笔记 | ...· 5 天前 ·

咆哮的馒头 · Get Nth Entry from ...· 4 天前 ·

留胡子的汤圆 · SharePoint 搜索 REST ...· 昨天 ·

没有腹肌的开水瓶 · Exception in thread ...· 昨天 ·

跑龙套的小蝌蚪 · 中共中央、国务院关于加强技术创新、发展高科技 ...· 1 月前 ·

聪明伶俐的枇杷 · Discussion of What ...· 3 月前 ·

发财的西装 · 快穿在总受文里抢主角攻np唐棠类似小说-胖樱 ...· 4 月前 ·

飘逸的野马 · 关于及时升级nginx ...· 5 月前 ·

干练的煎饼果子 · Genome ...· 7 月前 ·

K. Tsang wrote: SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd yyyy HH:mm:ss Z");

No it doesn't work

parseDateError.png

What value does you pass into the 2nd parameter for the parse() method? And not sure if the locale for the SimpleDateFormat is affecting it, you may want to remove the locale to test .

EDIT forget the 2nd parm in parse().

K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP

Jacky Luk wrote:

K. Tsang wrote: SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd yyyy HH:mm:ss Z");

No it doesn't work
ItDoesntWorkIsUseless (←click).

And I wouldn't post image links. For one thing, some people may not be able to view it (and my old eyes can't read it). Post the code and your error message - exactly as you got it.

Winston

"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here

// follows the cell format SimpleDateFormat sdf = new SimpleDateFormat("EEE MMM dd yyyy HH:mm:ss Z"); System.out.println("Date was " + tblSalesDetail.getValueAt(i,3).toString()); java.util.Date result = sdf.parse(tblSalesDetail.getValueAt(i,3).toString().trim()); java.sql.Date sqlDate = new java.sql.Date(result.getTime()); ot.setWarrantyExpiryDate(sqlDate); ot.setGrossSales((BigDecimal)tblSalesDetail.getValueAt(i,4)); ot.setQuantity(Integer.parseInt( tblSalesDetail.getValueAt(i,5).toString())); ot.setDiscount(Float.parseFloat( tblSalesDetail.getValueAt(i,6).toString())); ot.setNetSales(new BigDecimal( tblSalesDetail.getValueAt(i,7).toString()));
No, it won't do either. I am getting this error
java.text.ParseException: Unparseable date: "Fri Aug 30 00:00:00 CST 2013"
Thanks
Jack

Guess what the format I gave earlier doesn't work.
new SimpleDateFormat("EEE MMM dd HH:mm:ss Z yyyy");

K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP

K. Tsang wrote: Guess what the format I gave earlier doesn't work.
new SimpleDateFormat("EEE MMM dd HH:mm:ss Z yyyy");

Java VM is acting really strange at this. I don't know why, by logic, your string should work.
Now even this doesn't
Thanks
Jack

Does your code print out the date on line 7? Is tblSalesDetail.getValueAt(i,3) even a Date?

K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP

K. Tsang wrote: Does your code print out the date on line 7? Is tblSalesDetail.getValueAt(i,3) even a Date?

I have set a DefaultTableModel like this

where the forth column is a String (WarrantyExpirationDate)
And yeah, I've checked it, it is a string

It's a string alright. The table model can't be wrong right?

The weird thing I don't why this code doesn't work for you.

K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP

K. Tsang wrote: It's a string alright. The table model can't be wrong right?

The weird thing I don't why this code doesn't work for you.

Wait. Hold on a sec, it seems like tblSalesDetail.getValueAt(i,3) was not allowed, probably I was wrong
even though I have checked it using instanceof, it says it found an Object object, it needs to be casted to a string.
But I have done this before. tblSalesDetail.getValueAt(i,3).toString()
frown

Then your table model isn't returning the correct type.

EDIT: if it's Object, what does your instanceof operator say? Is it possible to cast it directly to java.util.Date?

K. Tsang CEng MBCS PMP PMI-ACP OCMJEA OCPJP

Jacky Luk wrote: Java VM is acting really strange at this. I don't know why, by logic, your string should work.

I seem to remember having problems with "MMM" before myself when parsing (but it was with French month abbreviations; possibly because you can't use 3-letter abbreviations with French months).

My advice: Forget about your table model and your GUI entirely, and set up a little test module and test the hell out of SimpleDateFormat. And try lots of different patterns , including maybe just "MMM" and "EEE" on their own, and see what you get.

Winston

"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here

Don't worry, Tsang, I've solved it using Joda Time.
Don't spend too much time on it. You've got other important things to do.

Cheers Thanks for helping

Jacky Luk wrote: Cheers Thanks for helping

Jacky,

Please DontWriteLongLines . It makes your thread very hard to read. I've broken yours up this time, but for future reference, please remember:
80 characters max .
(the SSCCE page actually recommends 62)
And that includes string literals AND comments.

Thanks.

Winston

"Leadership is nature's way of removing morons from the productive flow" - Dogbert
Articles by Winston can be found here

Jacky Luk wrote: Cheers Thanks for helping

What's that smell? Hey, sniff this tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/t/782867/Coderanch-server-fundraiser contact us | advertise |