#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Sacramento
    Posts
    50
    Rep Power
    14
    Hello,

    I have a field in a table called "CREATED" it's a mysql TIMESTAMP data type, when I display the contents of this field it looks like:

    000816

    I'd like it to display like:

    August 16, 2000

    Is there a good way to accomplish this in php?

    Thank you very much!
  2. #2
  3. Full Access
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jun 2000
    Location
    London, UK
    Posts
    2,019
    Rep Power
    17
    Like this:

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>

    <?

    print (date ("F j, Y"));

    ?>

    [/code]

    There's more on the date function at the PHP website: http://www.php.net/manual/function.date.php

    Hope this helps,

    --------------------------------------------
    Alex
    (http://www.alex-greg.co.uk)
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    Sacramento
    Posts
    50
    Rep Power
    14
    works great! Thank you!

Similar Threads

  1. DATE_ADD question where date YYYYMMDD
    By lottos in forum PHP Development
    Replies: 5
    Last Post: February 22nd, 2004, 07:53 PM
  2. quick mysql/php question
    By mirthika in forum PHP Development
    Replies: 2
    Last Post: February 16th, 2004, 02:15 PM
  3. Quick regex wildcard question.
    By s200 in forum PHP Development
    Replies: 2
    Last Post: February 12th, 2004, 09:09 AM
  4. PHP and Table Relationship question
    By spank in forum PHP Development
    Replies: 4
    Last Post: February 9th, 2004, 08:24 PM
  5. Php + Flash Question
    By ORANGE900 in forum PHP Development
    Replies: 0
    Last Post: January 23rd, 2004, 01:23 AM

IMN logo majestic logo threadwatch logo seochat tools logo