Professional Web Applications Themes

Help needed for TimeStamp conversion between MySQL and PHP - PHP Development

On Sun, 06 Jul 2003 19:17:58 GMT, "Steven" <xuemingcomcast.net> wrote: >TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend >on the size, but the timestamp for PHP would be the total seconds from >1/1/1970( or something like it). > >Any easy function to convert them ? [url]http://www.mysql.com/doentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions[/url] -- Andy Hassall (andyandyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url]) Space: disk usage ysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])...

  1. #1

    Default Re: Help needed for TimeStamp conversion between MySQL and PHP

    On Sun, 06 Jul 2003 19:17:58 GMT, "Steven" <xuemingcomcast.net> wrote:
    >TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend
    >on the size, but the timestamp for PHP would be the total seconds from
    >1/1/1970( or something like it).
    >
    >Any easy function to convert them ?
    [url]http://www.mysql.com/doentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions[/url]

    --
    Andy Hassall (andyandyh.co.uk) icq(5747695) ([url]http://www.andyh.co.uk[/url])
    Space: disk usage ysis tool ([url]http://www.andyhsoftware.co.uk/space[/url])
    Andy Hassall Guest

  2. #2

    Default Re: Help needed for TimeStamp conversion between MySQL and PHP

    "Steven" <xuemingcomcast.net> wrote in message
    news:GB_Na.51191$926.6117sccrnsc03...
    > TimeStamp in MySQL is unix timestamp like YYYYMMDDHHMMSS or shorter depend
    > on the size, but the timestamp for PHP would be the total seconds from
    > 1/1/1970( or something like it).
    >
    > Any easy function to convert them ?
    >
    > Regards,
    > -Steven
    >
    afaik a unix timestamp IS the number of seconds since 01/01/1970.

    in a mysql query you can use FROM_UNIXTIME(unix timestamp here) and
    UNIX_TIMESTAMP(mysql date column here)


    Ev0 Guest

Similar Threads

  1. Translating MySQL timestamp to datetime
    By Joshua Beall in forum PHP Development
    Replies: 1
    Last Post: April 22nd, 02:50 PM
  2. mysql date to timestamp
    By Ben in forum PHP Development
    Replies: 2
    Last Post: December 8th, 05:22 PM
  3. MySQL timestamp to desired date function
    By Cesar Aracena in forum PHP Development
    Replies: 2
    Last Post: September 18th, 11:39 AM
  4. mysql or php timestamp arithmatic
    By Christian Calloway in forum PHP Development
    Replies: 0
    Last Post: August 25th, 12:06 PM
  5. [PHP] convert mysql datetime to unix timestamp
    By Adam Voigt in forum PHP Programming
    Replies: 1
    Last Post: July 28th, 04:38 PM

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