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')?
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.