Cre8ve Zone - all cool things are here!!!!

Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

Saturday, August 27, 2011

Convert mysql datetime into some other format!!

Simply change your sql statement to :


SELECT DATE_FORMAT(thedate, '%M %e, %Y, %l:%i%p') as newdate FROM your_table; 



Posted by kamal at Saturday, August 27, 2011 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: datetime, mysql, php
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2011 (4)
    • ▼  August (1)
      • Convert mysql datetime into some other format!!
    • ►  May (2)
    • ►  March (1)
  • ►  2010 (4)
    • ►  October (1)
    • ►  August (1)
    • ►  April (2)
  • ►  2009 (1)
    • ►  January (1)

About Me

kamal
View my complete profile
Picture Window theme. Powered by Blogger.