Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unanswered: Change date format in a table....?

    Hello All,

    I have an easy one for you guys....

    A table (Bugzilla-installation) which was created in MySQL, uses the following (default I guess?) date format:

    yyyy-mm-dd

    We would like to change this to:

    dd-mm-yyyy

    What is important though, is that the change is made on the TABLE ITSELF and not that the query manipulates the date before insertion.

    Anybody can give me a hand?

  2. #2
    Join Date
    Jul 2003
    Posts
    35
    Hi,

    The manual spells out the following regarding the format of Date values stored in mysql tables (http://www.mysql.com/doc/en/Date_and_time_types.html)...

    "Although MySQL tries to interpret values in several formats, it always expects the year part of date values to be leftmost. Dates must be given in year-month-day order (for example, '98-09-04'), rather than in the month-day-year or day-month-year orders commonly used elsewhere (for example, '09-04-98', '04-09-98'). "

    ...which would mean that you are unable to store dates according to the format you desire.

    Obviously retrieving dates from mysql in the format you desire is straightforward.

    chrs,
    ash
    Last edited by asherh; 09-01-03 at 03:00.

Posting Permissions

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