This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

java.util.Date and java.sql.Date problem

 
tun zaw
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi

i use mysql database.User's date of birth is caught by java.util.Date in backing bean.while insert into database,mysql cannot accept.Cannot insert into table.Query not ok.if use java.sql.Date,also same result.
I have known sql.Date into mm/dd/yyyy.java.util.Date is little long.
if i use now() function in mysql,i can display like mm/dd/yyyy while i retrieve the date.
that is why?
Please help me.
 
Darryl Nortje
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Howzit Tun,

This is not a JSF question. So I assume someone is going to move this post. But I'll see if I can help anyway.

You want to convert from java.util.Date to a java.sql.Date. Is that correct?

have you try instantiating a java.sql.Date with the constructor that accepts a long as a parameter, and you get that long from java.util.Date.getTime()?
java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());
 
tun zaw
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks for your answer.
thank you very much.
tunzaw
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic