So what would a update command look like for updating a date field to the
current time

UPDATE X
Set MyDate = TIMESTAMP


I want the entire date and time to be stored.
Will the above be correct.