The SQLite documentation says datetimes must be in the format YYYY/MM/DD HH:mm:ss.xxx
My system format for dates is DD/MM/YYYY.
I painstakingly build up my date to store to be:
"2014/10/25 00:00:00.000"
It stores successfully with an INSERT INTO. No complaints.
With SQLiteManager I can see it looks exactly as saved.
Problem: When filling a dataset from the table I get "String was not recognised as a valid DateTime."
Does that mean that SQLite didn't recognise "2014/10/25 00:00:00.000" as valid?
If so, why not?
(I even tried removing the .xxx part to try and solve my problem.)
It is YYYY-MM-DD, not YYYY/MM/DD. Problem solved.
My system format for dates is DD/MM/YYYY.
I painstakingly build up my date to store to be:
"2014/10/25 00:00:00.000"
It stores successfully with an INSERT INTO. No complaints.
With SQLiteManager I can see it looks exactly as saved.
Problem: When filling a dataset from the table I get "String was not recognised as a valid DateTime."
Does that mean that SQLite didn't recognise "2014/10/25 00:00:00.000" as valid?
If so, why not?
(I even tried removing the .xxx part to try and solve my problem.)
It is YYYY-MM-DD, not YYYY/MM/DD. Problem solved.
Last edited: