Professional Web Applications Themes

Translating MySQL timestamp to datetime - PHP Development

Hi All, Any thoughts on the easiest way to translate a MySQL timestamp (which looks like 20040422090941) to the datetime format (which looks like 2004-04-22 09:09:41). This is just to make it easier for a human to read it. I have thought about splitting it into chunks using something like str_split, then piecing it back together, but it seems like there should be an easier way. And also, I am not running PHP5. I already tried date("Y-m-d H:i:s",strtotime("20040422090941")), and had no luck. strtotime cannot handle that format. This seems like the sort of thing you should be able to do ...

  1. #1

    Default Translating MySQL timestamp to datetime

    Hi All,

    Any thoughts on the easiest way to translate a MySQL timestamp (which looks
    like 20040422090941) to the datetime format (which looks like 2004-04-22
    09:09:41). This is just to make it easier for a human to read it.

    I have thought about splitting it into chunks using something like
    str_split, then piecing it back together, but it seems like there should be
    an easier way. And also, I am not running PHP5.

    I already tried date("Y-m-d H:i:s",strtotime("20040422090941")), and had no
    luck. strtotime cannot handle that format.

    This seems like the sort of thing you should be able to do in 1 line of
    code. Any pointers?

    -Josh


    Joshua Beall Guest

  2. #2

    Default Re: Translating MySQL timestamp to datetime

    Joshua Beall wrote:
    > Hi All,
    >
    > Any thoughts on the easiest way to translate a MySQL timestamp (which looks
    > like 20040422090941) to the datetime format (which looks like 2004-04-22
    > 09:09:41). This is just to make it easier for a human to read it.
    >
    > I have thought about splitting it into chunks using something like
    > str_split, then piecing it back together, but it seems like there should be
    > an easier way. And also, I am not running PHP5.
    >
    > I already tried date("Y-m-d H:i:s",strtotime("20040422090941")), and had no
    > luck. strtotime cannot handle that format.
    >
    > This seems like the sort of thing you should be able to do in 1 line of
    > code. Any pointers?
    >
    > -Josh
    Select the date value from MySQL as a Unix timestamp eg.

    SELECT UNIX_TIMESTAMP(date) as date FROM table

    Then you can use the date() function on it with no problems.
    DB McGee Guest

Similar Threads

  1. Replies: 1
    Last Post: January 19th, 06:25 PM
  2. mysql date to timestamp
    By Ben in forum PHP Development
    Replies: 2
    Last Post: December 8th, 05:22 PM
  3. mysql or php timestamp arithmatic
    By Christian Calloway in forum PHP Development
    Replies: 0
    Last Post: August 25th, 12:06 PM
  4. [PHP] convert mysql datetime to unix timestamp
    By Adam Voigt in forum PHP Programming
    Replies: 1
    Last Post: July 28th, 04:38 PM
  5. Help needed for TimeStamp conversion between MySQL and PHP
    By Andy Hassall in forum PHP Development
    Replies: 1
    Last Post: July 6th, 08:50 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