[SOLVED] Best Way To Insert Timestamp into DB record

[refiking]

I need the most simple method to get this accomplished.  DB Field is timestamp and the name is date_commit. I can not do an autoupdate for this field, either.  It only needs to be updated at certain times.  Not everytime the record is modified.

[DeanWhitehouse]

When you want to update it use NOW() as the value in the query

 

[Mchl]

UPDATE table SET date_commit = NOW()

[refiking]

should it be NOW() or 'NOW()'

[DeanWhitehouse]

Either (i think), it might read 'NOW()' literally though

[Mchl]

Without quotes. It's the name of MySQL function. If you put quotes around it, MySQL will think it is string.

[DeanWhitehouse]

Are you sure it doesn't parse the code like PHP does, and run the function instead of reading it literal

[Mchl]

Just tested it on DATETIME field. I'm pretty sure result on TIMESTAMP will be the same.

[revraz]

Try it and see.

 

Are you sure it doesn't parse the code like PHP does, and run the function instead of reading it literal

[DeanWhitehouse]

 

Btw if this is solved then click solved in the bottom left of the thread.