KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I need to figure out a way to insert a record with a java.util.Date field into a database and i'm stuck. Does anyone know how i can do this? Right now i have something like. java.util.Date myDate = new java.util.Date("01/01/2009"); sb.append("INSERT INTO USERS"); sb.append("(USER_ID, FIRST_NAME, LAST_NAME, SEX, DATE) "); sb.append("VALUES ( "); sb.append(" '" + userId + "'"); sb.append(", '" + myUser.GetFirstname() + "' "); sb.append(", '" + myUser.GetLastname() + "' "); sb.append(", '" + myUser.GetSex() + "' "); sb.append(", '" + myDate + "'"); sb.append(")"); Util.executeUpdate(sb.toString()); But when i run something like this i get the error: The syntax of the string representation of a datetime value is incorrect. Heres what the sql statement looks like: INSERT INTO USERS (USER_ID , FIRST_NAME , LAST_NAME , SEX , CRDATE) VALUES ( 'user' , 'FirstTest' , 'LastTest' , 'M' , 'Thu Jan 01 00:00:00 CST 2009') Thanks
Tags (comma-separated)
Save Edits
Cancel