string to date conversion

[Krish Khan]

Hello,

I am trying to upload data from excel sheet using servlets. I can do that but problem is

I am reading date from excel and storing in string its in dd/mm/yyyy h:mm formate now i try to insert into MS Sql DB its show error conversion failed while converting string to Datetime.

Pleas let me know how to convert Stirng to date time format I want in dd/mm/yyyy h:mm:ss

Thank you!

[Bear Bibeault]

As this has nothing to do with Servlets, it's been moved to a more appropriate location.

[Chiranjeevi Kanthraj]

Use SimpleDateFormat format = new SimpleDateFormat("dd/MM/yyyy h:mm");
Date date = format.parse("25/10/2010 1:09");


For more information on the argument for SimpleDateFormat see the link
SimpleDateFormat

[Krish Khan]

Hi Chiru ,

Thanks for your reply . I have used the same but i coudnt able to manage. Here is my code and output.

  
public void insertIntoNote(Connection con,String creditWise,String noteDate,String notes){
        Statement stmt = null;
        try{
//            //String str_date="11-June-07";
            System.out.println("date note :: "+noteDate);
            DateFormat formatter = new SimpleDateFormat("dd/mm/yyyy HH:mm");
            Date date  = formatter.parse(noteDate);
            System.out.println("Date::" +date);   

out put is :

line number:: 7
date note :: 22/09/2010 10:31
Date::Fri Jan 22 10:31:00 SGT 2010
line number:: 8
date note :: 22/09/2010 10:32
Date::Fri Jan 22 10:32:00 SGT 2010


i am getting date as Jan 22 10:32:00 SGT 2010

I want it as 22/01/2010 10:32:00

[Wouter Oet]

Date only has a format for debugging purposes. You can use the DateFormat to get it in format that you want.

[Jesper de Jong]

First of all, there is an error in line 7 of your code:

DateFormat formatter = new SimpleDateFormat("dd/mm/yyyy HH:mm");

This should have been:

DateFormat formatter = new SimpleDateFormat("dd/MM/yyyy HH:mm");

Note that you must use "MM" for the month, not "mm", because "mm" means minutes.

Krish Khan wrote:i am getting date as Jan 22 10:32:00 SGT 2010

Note that a Date object does not know anything about formatting by itself. If you print a Date object like you are doing in line 9 of your code, then a default format will be used to convert the Date to a String for display. If you want the date to be printed in a specific format, you must use the SimpleDateFormat object again to convert it to a string in the desired format:

System.out.println("Date::" + formatter.format(date));

[Krish Khan]

Hi Jasper,

Appreciate your response.

Yeah when i format it again it will change to String which cannot be inserted into database because the data field is datetime type.

All I want is converting the String to datetime type so that i can insert into database (MS SQL).

[Rob Spoor]

Use a PreparedStatement and its setTimestamp method:

Timestamp ts = new Timestamp(date.getTime());
statement.setTimestamp(index, ts);

That way there will be no problems with the formatting.

[Krish Khan]

Hi,

Can you give an example in my case.?

[Campbell Ritchie]

Go through the Java™ Tutorials.

[Krish Khan]

Thanks Mates I got it...