douweiluo0600 2016-09-18 09:58
浏览 177
已采纳

从GMT时间和用户时区计算时间

I have one mysql DB saving time for every record with GMT time for every user. like

id user_id   date_added
1  1        2016-06-08 12:22:19
2  2        2016-06-08 11:22:14
3  4        2016-06-08 11:02:09
4  1        2016-06-08 10:12:11

I also have table saved timezone for each user like

id  user_name   timezone
1   user1       Pacific/Midway
2   user2       Asia/Dubai

now i want to calculate real time for user record using above time zone in PHP.

i tried many examples but not working cause some zone are + and some are -

Thanks

  • 写回答

3条回答 默认 最新

  • dth20986 2016-09-18 10:35
    关注

    Assuming that all dates are stored in UTC date format, you need to convert the timezone to get the local time for each user.

    Example:

    // default timezone is UTC
    $date = new DateTime('2016-06-08 12:22:19', new DateTimeZone('UTC'));
    var_dump($date->format('Y-m-d H:i:sP'));
    
    // convert timezone to Asia/Dubai +4 UTC
    $date->setTimezone(new DateTimeZone('Asia/Dubai'));
    var_dump($date->format('Y-m-d H:i:sP'));
    

    The output will be

       string '2016-06-08 12:22:19+00:00' (length=25) 
       string '2016-06-08 16:22:19+04:00' (length=25)
    

    To get rid of +00 and +04 change the format by removing P

    $date->format('Y-m-d H:i:s')
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果