timestamp

[starfish]

how do we use timestamp?
what for do we use timestamp basically?
is that used while we set data type for the fields?
any help would be appreciated along with a simple example if possible!!

[Erik]

From the MySQL reference manual:

TIMESTAMP values are converted from the current time zone to UTC for storage, and converted back from UTC to the current time zone for retrieval. (This occurs only for the TIMESTAMP data type, not for other types such as DATETIME.)

-Erik