mysql> select str_to_date('4.3.2010г', '%d.%m.%Y') d1, str_to_date('29.11.2013  г', '%d.%m.%Y') d2;
+------------+------------+
| d1         | d2         |
+------------+------------+
| 2010-03-04 | 2013-11-29 |
+------------+------------+
1 row in set, 2 warnings (0.00 sec)

mysql> show warnings;
+---------+------+-----------------------------------------------+
| Level   | Code | Message                                       |
+---------+------+-----------------------------------------------+
| Warning | 1292 | Truncated incorrect date value: '4.3.2010     |
| Warning | 1292 | Truncated incorrect date value: '29.11.2013   |
+---------+------+-----------------------------------------------+
2 rows in set (0.00 sec)

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.5.28    |
+-----------+
1 row in set (0.00 sec)