Results 1 to 3 of 3
  1. #1

    Changing the view of the database date?


    I have a database with a table including blog entries and a date the date is set to year-month-day format, How can i change it to something else, as i tried to change it to day-month-year so it will look like 11 September 2009 for example


  2. #2
    Join Date
    May 2009
    766, or the appropriate documentation for your unnamed database.

  3. #3
    Join Date
    Jun 2009
    You can use like this

    select date_format(date, '%d %M %Y') as formatted_date from table_name;

    Where date is the name of your date field, and formatted_date is a variable name which you can use to retrieve the value.

Similar Threads

  1. Changing System Date
    By prashant1979 in forum Hosting Security and Technology
    Replies: 4
    Last Post: 11-08-2007, 12:58 PM
  2. Changing date on a VPS?
    By activeco in forum VPS Hosting
    Replies: 9
    Last Post: 08-29-2007, 03:02 AM
  3. Changing Clients' Billing Date
    By CCF Hosting in forum Running a Web Hosting Business
    Replies: 10
    Last Post: 09-07-2004, 11:10 AM
  4. Changing date language without changing locale. (PHP)
    By hdezela in forum Programming Discussion
    Replies: 1
    Last Post: 09-06-2003, 01:54 PM
  5. Changing date, time zone?
    By Eiv in forum Hosting Security and Technology
    Replies: 1
    Last Post: 01-22-2002, 04:22 AM

Posting Permissions

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