Allow incomplate dates in MySQL connector
I need to use following dates for example: 2020-00-00 saved as DATE type. I set sql_mode in my sessionVariables to: 'ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION, ALLOW_INVALID_DATES'
It should allows me to provide such dates. However when I connect to database from phpStorm it shows me that value: 2019-11-30 - which isn't correct.
Is there any way to fix it?
请先登录再写评论。
Hello,
There's no option to do that at the moment.
Please vote for https://youtrack.jetbrains.com/issue/DBE-390 with thumb up button.