Convert string to date in mysql

Mysql provides an easy to use function to convert string to date/datetime

STR_TO_DATE(string, format)

Example

SELECT STR_TO_DATE('01/12/2012', '%d/%m/%Y')

Output

2012-12-01

Get Free Email Updates!

Signup now and receive free offers, discounts & coupon codes

I will never give away, trade or sell your email address. You can unsubscribe at any time.

Leave a Reply

Your email address will not be published. Required fields are marked *

CommentLuv badge