MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Converting DATE to INT
Posted by: Peter Brawley
Date: January 19, 2015 12:26PM

> I would like to convert the date 2011-04-20 to the integer 20110420

date_format(date_value,'%Y%m%d')

But as Phillip says, do not store it that way.

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


Subject
Written By
Posted
Converting DATE to INT
Thomas Rendal
January 18, 2015 02:33AM
Re: Converting DATE to INT
Phillip Ward
January 19, 2015 06:07AM
Re: Converting DATE to INT
Peter Brawley
January 19, 2015 12:26PM
Re: Converting DATE to INT
Rick James
January 19, 2015 10:56AM


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.