swuppio/date to time

Created February 2, 2017 15:18

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/swuppio/96802da580b1e180ccafaad1061294a5.js"></script>
Save swuppio/96802da580b1e180ccafaad1061294a5 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

date to time

SELECT DATE_FORMAT(STR_TO_DATE('10.11.2012 11:10:12','%d.%m.%Y %H:%i:%s'),'%Y-%m-%d %H:%i:%s');

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment