MySQL Forums :: Database Administration :: change date format in MYSQL

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	12/18/2006 02:56AM
Re: change date format in MYSQL	Bob Field	12/18/2006 09:34AM
Re: change date format in MYSQL	Pradeep Vecha	12/18/2006 11:39PM
Re: change date format in MYSQL	Bob Field	12/19/2006 09:56AM
Re: change date format in MYSQL	Pradeep Vecha	12/21/2006 02:12AM
Re: change date format in MYSQL	Paul Karunakar	02/08/2008 10:53PM
Re: change date format in MYSQL	nirav panchal	06/10/2008 12:55AM
Re: change date format in MYSQL	Peter Brawley	06/10/2008 02:35PM
Re: change date format in MYSQL	Dharma raj	07/28/2007 05:35AM
Re: change date format in MYSQL	naveen kumar	08/27/2007 12:50AM
Re: change date format in MYSQL	anupam tripathi	07/29/2008 02:09AM
Re: change date format in MYSQL	anupam tripathi	07/29/2008 02:05AM
Re: change date format in MYSQL	Erik Cerpnjak	02/01/2009 12:39PM
Re: change date format in MYSQL	Javedali Shaikh	03/30/2009 01:44AM
Re: change date format in MYSQL	Aftab Khan	03/30/2009 02:51AM
Re: change date format in MYSQL	larsen mcalister	04/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.