View Full Version : timestamp

13 Feb 2009, 07:06 AM
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!!

13 Feb 2009, 11:27 AM
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.)