Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Date Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Date" Watch "Date" New topic
Author

Date

satishind Reddy
Ranch Hand

Joined: Oct 17, 2000
Posts: 33
Hi,
I have a table in Microsoft SQL data base. In that table one field is a Date field. I am getting error while inserting record. I am giving code snippet please help me. what am I doing wrong here.

Thanks in advance.
Regards
Satish


[This message has been edited by Thomas Paul (edited December 07, 2000).]
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Parsing the date in this way will simply remove the portions of the date that are not year-month-day but will not effect what is passed to the datatbase which is: 'Thu Dec 07 00:00:00 EST 2000'.
You need to use the SimpleDateFormat to convert the Date object into a String. Try this:
SimpleDateFormat fmt = new SimpleDateFormat ("MM/dd/yyyy");
String todate = fmt.format(date);


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
satishind Reddy
Ranch Hand

Joined: Oct 17, 2000
Posts: 33
Hi Thomas,
Thanks for reply. Still it is giving problem because in table level my date field data type is 'datetime'.
SimpleDateFormat fmt = new SimpleDateFormat ("MM/dd/yyyy");
String todate = fmt.format(date);
here 'todate' is string. and table level field data type is 'datetime'. so it is giving data mismatch error.
please help to me. If i am not clear i can send code if u provide mail id.
Thanks
Satish
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
All you have to do is figure out what is a valid String format that MS SQL will accept in a date/time field and then use SimpleDateFormat to reproduce that format.
maha anna
Ranch Hand

Joined: Jan 31, 2000
Posts: 1467
Hi Reddy,
The following is the code snippet which I use in My-SQL and Access. It may not be same in MS-SQL. You can try it. Otherwise please look into the documentation. In the foll. code the DOB(DateOfBirth) String has to be in yyyymmdd format
regds
maha anna

[This message has been edited by Thomas Paul (edited December 08, 2000).]
satishind Reddy
Ranch Hand

Joined: Oct 17, 2000
Posts: 33
Hi paul,
Paul i havn't noticed that 'MM' should be Caps otherwise it is taking minutes insted of month. Due to this i got error every time.
Thanks for all your replies.
Satish
Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
That will make a difference. Glad that your problem is solved!
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Date
 
Similar Threads
Class java.sql.Date
How to get all request stored in databse between two date
Converting String to util.Date and then sql.Date
Convert Calendar object to Date object
ResultSet rs = prestatement.executeQuery()