I'm sure this has been covered before but I could not find it in the forum, nor a google search has helped my much.
I can read dates from the Database as they are stored in ticks, and this can be solved when putting them into a table, etc.
My problem is when I want to INSERT INTO Table1 a Date.
I can put the date into ticks with DateTime.DateParse(txtDate.Text) but using jRDC.insertRecord the jRDCServer response is
<title>Error 500 org.hsqldb.HsqlException: data exception: invalid datetime format: java.text.ParseException: Unparseable date: "1620252000000"</title>
Can anyone help me to solve this problem. I prefer to keep the dates in the database as DATE/TIME and not convert to TEXT as there is a lot of calculating using the dates.
Thanks ever so much
I can read dates from the Database as they are stored in ticks, and this can be solved when putting them into a table, etc.
My problem is when I want to INSERT INTO Table1 a Date.
I can put the date into ticks with DateTime.DateParse(txtDate.Text) but using jRDC.insertRecord the jRDCServer response is
<title>Error 500 org.hsqldb.HsqlException: data exception: invalid datetime format: java.text.ParseException: Unparseable date: "1620252000000"</title>
Can anyone help me to solve this problem. I prefer to keep the dates in the database as DATE/TIME and not convert to TEXT as there is a lot of calculating using the dates.
Thanks ever so much