Date Conversion from String to sql Date in Java giving different output

Question

I have a string form of Date  I have to change it to Sql Date  so for that i have used the following code    String startDate  01-02-2013   SimpleDateFormat sdf1   new SimpleDateFormat  dd-mm-yyyy    java util Date date   sdf1 parse startDate   java sql Date sqlStartDate   new java sql Date date getTime         when i used the above code and run that  I got the following output     2013-01-01      Here Month is not converted correctly  Please tell me where is the problem and provide sample code to get correct result

User · Answer

While using the date formats  you may want to keep in mind to always use MM for months and mm for minutes  That should resolve your problem

User · Answer

mm is minutes  You want MM for months   SimpleDateFormat sdf1   new SimpleDateFormat  dd-MM-yyyy      Don t feel bad - this exact mistake comes up a lot

User · Answer

That is the simple way of converting string into util date and sql date   String startDate  12-31-2014   SimpleDateFormat sdf1   new SimpleDateFormat  MM-dd-yyyy    java util Date date   sdf1 parse startDate   java sql Date sqlStartDate   new java sql Date date getTime

User · Answer

mm stands for  minutes   Use MM instead   SimpleDateFormat sdf1   new SimpleDateFormat  dd-MM-yyyy

User · Answer

You need to use MM as mm stands for minutes   There are two ways of producing month pattern   SimpleDateFormat sdf1   new SimpleDateFormat  dd-MM-yyyy      outputs month in numeric way  2013-02-01  SimpleDateFormat sdf2   new SimpleDateFormat  dd-MMM-yyyy       Outputs months as follows  2013-Feb-01   Full coding snippet           String startDate  01-Feb-2013      Input String         SimpleDateFormat sdf1   new SimpleDateFormat  dd-MM-yyyy       New Pattern         java util Date date   sdf1 parse startDate      Returns a Date format object with the pattern         java sql Date sqlStartDate   new java sql Date date getTime             System out println sqlStartDate      Outputs   2013-02-01

[java] Date Conversion from String to sql Date in Java giving different output?

Examples related to java

Examples related to date

Examples related to type-conversion