Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New Coder
    Join Date
    Sep 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mysql Date & Time with Timezone

    PHP 4.4 - MySQL 4.1
    ----------------------

    My clients are access my application from deferent timezone. I've stored my clients Timezone in a Table.
    When one access my page I have to store his access Date & Time in my database.
    When he or I will see his access information my application has to show date & time as his/my local timezone.

    I'm very much confused about the date & time in PHP+mysql.
    Now how can I store the GMT Date & time ?



    Please Help.

  • #2
    New Coder
    Join Date
    Sep 2007
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Can i set Timestamp ? or anyother?
    What i have to use time(), NOW() or any other?
    Which way

  • #3
    Super Moderator Inigoesdr's Avatar
    Join Date
    Mar 2007
    Location
    Florida, USA
    Posts
    3,642
    Thanks
    2
    Thanked 405 Times in 397 Posts
    gmdate(). You should also look into date_default_timezone_set() and the whole Date/Time function list.


  •  

    Posting Permissions

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