#1
  1. No Profile Picture
    mrtesting
    Guest
    Devshed Newbie (0 - 499 posts)
    how to format and display only the date from timestamp ?

    currently it shows :-

    Date : 19990827110223

    i want it to show :- 27 / 08 / 1999

    Thanks cause i appreciate your help.
  2. #2
  3. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    Try this query:

    SELECT DATE_FORMAT(columnName,'%d/%m/%Y') FROM tableName;

    For othere date/time related functions take a look at the docs:
    http://www.devshed.com/Server_Side/M...time_functions

Similar Threads

  1. date format display gone wrong
    By icepricessa in forum ASP Programming
    Replies: 3
    Last Post: September 27th, 2003, 07:21 AM
  2. JSP date format with Microsoft Access
    By fill in forum Java Help
    Replies: 1
    Last Post: July 30th, 2003, 04:35 PM
  3. format date and order by date
    By ryder in forum PHP Development
    Replies: 2
    Last Post: February 13th, 2003, 02:08 PM
  4. Display date in another format
    By quiquedcode in forum PHP Development
    Replies: 4
    Last Post: November 4th, 2001, 03:10 PM
  5. MySQL > timestamp > date format
    By jonny in forum PHP Development
    Replies: 9
    Last Post: November 3rd, 2001, 06:00 PM

IMN logo majestic logo threadwatch logo seochat tools logo