#1
  1. No Profile Picture
    chinnavi
    Guest
    Devshed Newbie (0 - 499 posts)

    hai
    i have a table that is having a TIMESTAMP and i wanna print DATE as a user readable format ...Like May 6,1999...
    But if i print date in the use environment it is printing ...
    20000723141903
    wht should i do to print date in user readable format

    vijay
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    Look at the function date_format() in the MySQL manual.

Similar Threads

  1. Inaccurate timestamp
    By duckumu in forum PHP Development
    Replies: 1
    Last Post: September 14th, 2003, 06:30 PM
  2. Replies: 0
    Last Post: May 5th, 2003, 07:59 AM
  3. Problem with printing
    By laurence10 in forum Java Help
    Replies: 0
    Last Post: March 11th, 2003, 03:09 PM
  4. incorrect sorting of Unix timestamp
    By vladiator in forum MySQL Help
    Replies: 2
    Last Post: October 12th, 2001, 03:42 PM
  5. Printing TIMESTAMP?
    By chinnavi in forum Perl Programming
    Replies: 1
    Last Post: July 24th, 2000, 01:55 PM

IMN logo majestic logo threadwatch logo seochat tools logo