Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Posts
    173

    Unanswered: date formatting question

    Is there a way to have mysql store dates as MM/DD/YYYY instead of YYYY-MM-DD?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    You are confusing the way that dates display with the way that they are stored. yyyy-mm-dd is closer to how they are stored than mm/dd/yyyy is, but only a little bit. You probably need to review the Date and Time Functions, specifically the DATE_FORMAT function to see how to get what you'd like.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •