Data MoverSQL error. Stmt #: 0 ORA-01830 date format picture ends before converting entire input string.

Data Mover throws this error when it doesn't support the specified date format.
Dafault Date format should be in the following format:  'YYYY-MON-DD'