SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Evangelist
    Join Date
    Oct 2000
    Posts
    407
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    timestamp problem

    I want to use mktime to insert the date of data in my database, but what type of cell should I use? A TIMESTAMP or DATETIME?

    Is mktime always adjusted after a specific timezone (Like GMT) or after the clock on the server?

  2. #2
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    mktime on it's own defaults to server local. You can modify the attributes to get timeonze accurate data. MySQL timestamp is sifferent than PHP's. If you are using PHP, just use an INT field. If you are using MySQL, use either one and don't worry about PHP.
    Aaron Brazell
    Technosailor



  3. #3
    SitePoint Evangelist
    Join Date
    Oct 2000
    Posts
    407
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for the help!


Bookmarks

Posting Permissions

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