Results 1 to 2 of 2

Thread: timestamp

  1. 13 Feb 2009, 07:06 AM #1
    starfish
    starfish is offline Established Member
    Join Date
    Nov 2008
    Posts
    25

    timestamp

    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!!
    Reply With Quote Reply With Quote
  2. 13 Feb 2009, 11:27 AM #2
    Erik
    Erik is offline Established Member
    Join Date
    Feb 2009
    Location
    Canada eh!
    Posts
    41
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules