I need to insert a date variable into DB. The field in DB table is date. The date is in default format 'yyyy-mm-dd'. I try to use statement like this and didn't work. Any idea?
String wkEnding = "2004-01-19";
sql = "Insert into Timesheet Wk_Ending values( {d '" + wkEnding + "'} )";