STR_TO_DATE Problem

[newbieBrian]

Hi All,

Please test it out.

[CODE=mysql]SELECT STR_TO_DATE('01/01/69','%m/%d/%y');[/CODE]


I got this result:
2069-01-01

Please help to make it to 1969-01-01. Thanks

[mwasif]

Kindly do not ask questions in MySQL Articles area. I am moving it to MySQL Forum.

[newbieBrian]

Hi All,

Please test it out.

[CODE=mysql]SELECT STR_TO_DATE('01/01/69','%m/%d/%y');[/CODE]


I got this result:
2069-01-01

Please help to make it to 1969-01-01. Thanks

I fixed the problem.