Professional Web Applications Themes

Changing date format - MySQL

Hi, I have a MySql database table USERS with about a 1000 records. I have a field called Date_joined where the date is stored in the format like Fri Feb 24 10:03:46 PST 2006. How can I convert this date format to 02/24/2006? Is there any query that would convert this field for all the records?...

  1. #1

    Default Changing date format

    Hi,

    I have a MySql database table USERS with about a 1000 records.

    I have a field called Date_joined where the date is stored in the
    format like Fri Feb 24 10:03:46 PST 2006.

    How can I convert this date format to 02/24/2006?

    Is there any query that would convert this field for all the records?

    mohammed.naghman@gmail.com Guest

  2. #2

    Default Re: Changing date format

    Hi,

    Just check out the following link: ( self explanatory )
    http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html

    Read about the 2 functions you need:

    STR_TO_DATE(str,format)

    AND

    DATE_FORMAT()

    They do the magic (for your case you need the first one only)
    Hope it helps.

    Cheers,
    Dragomir Stanchev

    -------------------------
    com wrote: 

    The|Godfather Guest

  3. #3

    Default Re: Changing date format


    The|Godfather wrote: [/ref]

    Consider storing the date in the mysql datetime format (YYYY-MM-DD
    HH:MM:SS) and then displaying it in whatever format you like when you
    retrieve it.

    strawberry Guest

Similar Threads

  1. changing language date format
    By Gert in forum FileMaker
    Replies: 3
    Last Post: November 10th, 09:51 PM
  2. Time/Date format and changing time to GMT
    By Shaiboy_UK in forum ASP
    Replies: 1
    Last Post: October 19th, 01:04 PM
  3. Changing file format?
    By brian11 webforumsuser@macromedia.com in forum Macromedia Fireworks
    Replies: 15
    Last Post: October 8th, 05:18 PM
  4. converting date into database date format(newbie)
    By Binay Agarwal in forum PHP Development
    Replies: 2
    Last Post: August 29th, 01:09 PM
  5. HTML changing format
    By Tobe in forum ASP.NET General
    Replies: 1
    Last Post: June 25th, 02:41 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