#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    24
    Rep Power
    0
    Hi,

    I am new to this php/MySQL stuff and just finished setting up a database and some php to query it. But I ran into an unforseen problem when it comes to converting dates using PHP. PHP seems to like its dats in the 'yyyymmdd' format and in the database i created the dates are in 'yyyy-mm-dd' format. Is there any easy way to change the format in yhe mySQL database without re-entering all the info?

    Any help would be appreciated thanks

    CMatrix
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Check out the date_format function of MySQL.

Similar Threads

  1. Changing date from date ("Ymd");
    By byte me in forum PHP Development
    Replies: 13
    Last Post: September 28th, 2006, 07:34 AM
  2. WHM account creation error messages on RH
    By borisbaloney in forum Linux Help
    Replies: 0
    Last Post: December 16th, 2003, 06:54 PM
  3. Php & Mysql date formats?
    By Neo Ported in forum PHP Development
    Replies: 2
    Last Post: November 24th, 2003, 05:24 PM
  4. Changing date?
    By eliteboo in forum Linux Help
    Replies: 3
    Last Post: April 2nd, 2003, 09:53 PM
  5. Changing date formats
    By Marky_Mark in forum MySQL Help
    Replies: 4
    Last Post: February 28th, 2002, 08:27 PM

IMN logo majestic logo threadwatch logo seochat tools logo