mysql - Converting string to date returning null -
i trying convert string in sql database date can order date.
'16 jul 2016' example of date format , using following code convert output null.
str_to_date( `date` , '%dd %mon %yyyy' ) thedatething
use correct format string:
str_to_date(date, '%d %b %y')
you seem have strange mix of oracle , mysql formats in string. mysql documentation quite clear.
Comments
Post a Comment