MySQL Timestamp

Anon

Hello,

How do I get php to update the timestamp in mysql? The format that i'm getting in mysql is '20011228145709', but I can't find a way to have php update that value. Any help would be greatly appreciated.

yendor

Are you talking about updating a timestamp in a database? If so you have many options. You could do it with a simple query using PHP.

$query = "UPDATE table SET timestamp=NOW() where ...etc..";

When that query is run PHP will set the timestamp field to the current MySQL timestamp.

HTH,
Rodney

Anon

Thanks

yendor

Sorry, I was mistaken.
You'll have to use NOW()+0, because NOW() is in the format YYYY-MM-DD hh:mm:ss. Whereas NOW()+0 will give you YYYYMMDDhhmmss, which is what you actually want.

Anon

I used NOW(), and it seemed to work fine.

Anon

NOW() will work, you don't need the +0 (MySQL's date handling functions are excellent)

Anon

If it works, use it. I was thinking of older versions of MySQL. I usually use PHP to handle all of my timestamps and date manipulation.