getting GMT time from from_unixtime

Ask a Question related to MySQL, Design and Development.

  1. #1

    Default getting GMT time from from_unixtime

    PHP has a function - gmdate - whereby one can get the GMT time from a
    timestamp. How might I do something like what this function does in
    MySQL? convert_tz seems like it might be an option were it not for the
    fact that convert_tz seems to require you know, in advance, the current
    timezone...

    yawnmoth Guest

  2. Similar Questions and Discussions

    1. CFMX7.0.1 Administrator date time issue showing 13hrsbehind server time
      I am running a W2k SP4 box that has been upgraded from CFMX6 to CFMX7.0.1. The CFMX7.0.1 server is showing the date on the Server Settings >...
    2. Child control renders at desing-time as if it is in run-time...
      Hi, I have a problem with design-time. The problem is rather hard to describe in a few sentences ... so I hope someone will reply asking for more...
    3. Access to UTC time with severs running in local time
      I am running server under Linux. Can I get the UTC time in servers with SQL sentences ? The 'current' and 'today' options always return local...
    4. server time vs browser time on cookie expirations
      Say, I want to set a cookie and have it expire an hour after it's set. It's looking like this is only possible for browsers which are in the same...
  3. #2

    Default Re: getting GMT time from from_unixtime


    yawnmoth wrote:
    > PHP has a function - gmdate - whereby one can get the GMT time from a
    > timestamp. How might I do something like what this function does in
    > MySQL? convert_tz seems like it might be an option were it not for the
    > fact that convert_tz seems to require you know, in advance, the current
    > timezone...
    eh?

    UTC_TIMESTAMP *IS* GMT time

    !?!?!?!?

    strawberry Guest

  4. #3

    Default Re: getting GMT time from from_unixtime

    Quote Originally Posted by strawberry View Post
    yawnmoth wrote:

    eh?

    UTC_TIMESTAMP *IS* GMT time

    !?!?!?!?
    yes, but it takes no argument
    Unregistered Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139