aspose file tools*
The moose likes Beginning Java and the fly likes string to date conversion Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "string to date conversion" Watch "string to date conversion" New topic

string to date conversion

Krish Khan
Ranch Hand

Joined: Dec 14, 2009
Posts: 46

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
Author and ninkuma

Joined: Jan 10, 2002
Posts: 61646

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

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Chiranjeevi Kanthraj
Ranch Hand

Joined: Feb 18, 2008
Posts: 290

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

Krish Khan
Ranch Hand

Joined: Dec 14, 2009
Posts: 46
Hi Chiru ,

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

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
Saloon Keeper

Joined: Oct 25, 2008
Posts: 2700

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

"Any fool can write code that a computer can understand. Good programmers write code that humans can understand." --- Martin Fowler
Please correct my English.
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14345

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

This should have been:

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:

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
Krish Khan
Ranch Hand

Joined: Dec 14, 2009
Posts: 46
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

Joined: Oct 27, 2005
Posts: 19760

Use a PreparedStatement and its setTimestamp method:
That way there will be no problems with the formatting.

How To Ask Questions How To Answer Questions
Krish Khan
Ranch Hand

Joined: Dec 14, 2009
Posts: 46

Can you give an example in my case.?
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 39826
Go through the Java™ Tutorials.
Krish Khan
Ranch Hand

Joined: Dec 14, 2009
Posts: 46
Thanks Mates I got it...
I agree. Here's the link:
subject: string to date conversion