CODEWITHSUNDEEP
sqlite
MarkyMark1000
MarkyMark1000

Reputation: 437

SQLite, Update Statement using DateTime

I have been trying to update a datetime column using the following SQL Statement:

UPDATE HistoricData SET RecordDate=DATETIME(RecordDate,'60 minutes') WHERE DataStreamID=1 AND TimeFrameID=5

However, I keep getting the following error message:

NOT NULL Constraint Failed: HistoricData.RecordDate

If you could recommend the appropriate change to get this working, I would very much appreciate it.

I will attempt to attach a sample schema and data:

Table Data

Table Schema

Upvotes: 0

Views: 714

Answers (1)

ZorgoZ
ZorgoZ

Reputation: 3569

After inspecting your DML, my only remaining concern was the datetime format you have in your table. I tried updating such a value as you did, and guess what, it returns NULL: http://sqlfiddle.com/#!7/f4651/10 Why? Because your strings (do notation) are not valid ISO-8601 strings. You probably need to simply replace the dots with dashes before updating (http://sqlfiddle.com/#!7/f4651/11).

Upvotes: 1

Related Questions