MySQL Forums
Forum List  »  Database Administration & Monitoring

Advanced Search
New Topic

Re: change date format in MYSQL
Posted by: Bob Field
Date: December 18, 2006 09:34AM

The MySQL date format is actually YYYY-MM-DD, but using the str_to_date() and date_format() functions you can accept and generate any date format required.

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
change date format in MYSQL
Pradeep Vecha
December 18, 2006 02:56AM
Re: change date format in MYSQL
Bob Field
December 18, 2006 09:34AM
Re: change date format in MYSQL
Pradeep Vecha
December 18, 2006 11:39PM
Re: change date format in MYSQL
Bob Field
December 19, 2006 09:56AM
Re: change date format in MYSQL
Pradeep Vecha
December 21, 2006 02:12AM
Re: change date format in MYSQL
Paul Karunakar
February 08, 2008 10:53PM
Re: change date format in MYSQL
nirav panchal
June 10, 2008 12:55AM
Re: change date format in MYSQL
Peter Brawley
June 10, 2008 02:35PM
Re: change date format in MYSQL
Dharma raj
July 28, 2007 05:35AM
Re: change date format in MYSQL
naveen kumar
August 27, 2007 12:50AM
Re: change date format in MYSQL
anupam tripathi
July 29, 2008 02:09AM
Re: change date format in MYSQL
anupam tripathi
July 29, 2008 02:05AM
Re: change date format in MYSQL
Erik Cerpnjak
February 01, 2009 12:39PM
Re: change date format in MYSQL
Javedali Shaikh
March 30, 2009 01:44AM
Re: change date format in MYSQL
Aftab Khan
March 30, 2009 02:51AM
Re: change date format in MYSQL
larsen mcalister
April 07, 2009 02:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.