SQLite Update date SQL

Question

SQLite Newbie

I am trying to update a table with a date.

Something like this:

Update MyTable Set MyCol=GetDate()

What is the correct syntax?

Answer 1

 UPDATE table SET datecol=date('now')

This'll set the whole table to the date now.

 UPDATE table SET datecol=date('now') WHERE id=666

Or if it's a datetime column, datetime('now')

Answer 2

You have a complete reference here.

To update to the current date/time do this:

update mytable set mycol=date('now')