MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Converting DATE to INT
Posted by: Thomas Rendal
Date: January 18, 2015 02:33AM

Looking on the web i see examples converting a Date to an INT by using UNIX_TIMESTAMP. However, I would like to convert the date 2011-04-20 to the integer 20110420. Is there a build-in function which doe this?

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.