Fixed parseTime and DATE #881 issue

[SMahdiFaghih]

Description

add format so that when the target is DATE, it won't change into DATETIME

Checklist

• [ ] Code compiles correctly
• [ ] Created tests which fail without the change (if possible)
• [ ] All tests passing
• [ ] Extended the README / documentation, if necessary
• [ ] Added myself / the copyright holder to the AUTHORS file

[methane]

I don't like this. It makes unnecessary conversion and allocation for all other use cases.

I think #881 is a limitation of the current database/sql design. Please don't try to fix it only in the driver side.

[howoii]

Will there be a good solution in a future version for #881 ？

[methane]

Will there be a good solution in a future version for #881 ？

If you want to use DATE or TIME type, do not use parseTime=true at all. You can get string form and parse it manually.