SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    874
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Mysql Standard TimeStamp

    Dear All,
    I am building an application where it will store data locally and at some interval the data will be updated to a central database. So what I worried is about the date time information which I store. I find that now if I change my local time then it takes that time. How can I ensure that throught all my client the data time is following one standard? Thank you.

  2. #2
    Follow Me On Twitter: @djg gold trophysilver trophybronze trophy Dan Grossman's Avatar
    Join Date
    Aug 2000
    Location
    Philadephia, PA
    Posts
    20,580
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Choose a time zone, and convert all dates to that time zone before storing them.

  3. #3
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    874
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Dan,
    Can you give me some hints on how to do it? I am not so clear is it set default-time-zone= ?

  4. #4
    SitePoint Guru
    Join Date
    Feb 2007
    Posts
    874
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Dear Dan,
    Ok I have set into my ini file default-time-zone = '+08:00' but when I change my pc time and when I do SELECT NOW(); it gives me the time as according to my pc time changes. Thank you.


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
  •