Professional Web Applications Themes

getting GMT time from from_unixtime - MySQL

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......

  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. #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

  3. #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

Similar Threads

  1. CFMX7.0.1 Administrator date time issue showing 13hrsbehind server time
    By bayfield in forum Coldfusion Server Administration
    Replies: 0
    Last Post: December 8th, 04:34 AM
  2. Formatting a time field to 24 hour time (Military time) in the Datagrid
    By David Hearn in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: September 10th, 02:50 PM
  3. Access to UTC time with servers running in local time
    By Michael Mueller in forum Informix
    Replies: 2
    Last Post: August 27th, 05:34 AM

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
  •  

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