SQLite Update date SQL

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?

 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')

You have a complete reference here.

To update to the current date/time do this:

update mytable set mycol=date('now')

time Update According to below Query But One Query How Update Both Date And Time?

UPDATE mytable SET mycol=Time('now')