About timestamp 1

[mrdance]

1. How can I select and format the timestamp to, for example YYYY-MM-DD?

2. Timestamp updates only the row inserted not the whole table, right?

thanks

--- neteject.com - Internet Solutions ---

 

[TonyGroves]

You could use:[tt]
SELECT LEFT(timestampfield,10) FROM tblname;
[/tt]or:[tt]
SELECT DATE_FORMAT(timestampfield,"%Y-%m-%d') FROM tblname;
[/tt]

If you insert or update a record with a timestamp field without assigning a value to the timestamp, then the field will be set to the current date/time. This applies only to the record being inserted or updated.