Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

smalldatetime format error

 
Kevin P Smith
Ranch Hand
Posts: 362
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Probably quite a simple problem but...

I have a simple form where a user inputs some data (including a date), I want the user to eneter the date in dd/mm/yyyy format (e.g. 21/02/2005), my SQL database is using 'smalldatetime' format, which as i see stores the date in dd/mm/yyy format. So, there shouldn;t be a problem should there? So why is it, when I insert a new record i get a:

"java.sql.SQLException: The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value." error? Is it because I don;t have any time values on the end of the date (e.g. 21/02/2005 00:00:00.00 or summin')?

Cheers

K.
 
myriah wind
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
post the code
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34375
345
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I strongly recommend using a prepared statement here. You can parse the date in Java and then pass the date object into a stored procedure. This allows the driver to deal with conversion details.
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
K,
Does "mySQL" support SQL Escape Syntax?

Good Luck,
Avi.
 
Kevin P Smith
Ranch Hand
Posts: 362
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's OK I changed it from smalldatetime to just datatime, that seems to have fixed it for some reason.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic