Convert textual dates of the form '[d]d-[m]m-yyyy' to actual dates

/ Published in: MySQL
Save to your folder(s)

Converts textual dates like '1-3-1954' and '01-02-1963' to respectively '1954-3-1' and '1963-02-01'. MySQL is smart enough to understand the values without leading zeros when inserting into a DATE field.

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.