• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Date format

 
santosh garg
Greenhorn
Posts: 10
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have date in textbox which I am getting in MM-DD-YYYY format but I have to insert into mysql database which accepts it in yyyy-mm-dd format. is there any way to convert it.

I have tried with the following code

java.text.DateFormat format = new java.text.SimpleDateFormat("yyyy-MM-dd");
java.util.Date mySDate = format.parse(sdate);
java.util.Date myEDate = format.parse(edate);

but it gives me java.text.SimpleDateFormat(unknown) error.
please anyone provide me solution for this.

Thanks in advance
 
Sagar Rohankar
Ranch Hand
Posts: 2905
1
Java Spring Ubuntu
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
santosh garg wrote:I have date in textbox which I am getting in MM-DD-YYYY format but I have to insert into mysql database which accepts it in yyyy-mm-dd format. is there any way to convert it.

I have tried with the following code

java.text.DateFormat format = new java.text.SimpleDateFormat("yyyy-MM-dd");
java.util.Date mySDate = format.parse(sdate);
java.util.Date myEDate = format.parse(edate);

but it gives me java.text.SimpleDateFormat(unknown) error.
please anyone provide me solution for this.


I don't know whats this error about, but what I thought for this is, You need to make first instance of SimpleDateFormat class which takes "MM-dd-yyyy" format , then parse the date you are receiving as a string, this makes a "Date" object of your format. Once you get the Date from string convert it into "yyyy-MM-dd", using another instance of SimpleDatFormat class..

Try this..
 
Eric Pascarello
author
Rancher
Posts: 15385
6
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Has nothing to do with JavaScript/HTML. Moving to JIG B

Eric
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic