Allow incomplate dates in MySQL connector

Avatar
sabat24
Created

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?

Votes

0

Share

1 comment
Avatar
Permanently deleted user
Created

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.

0

Please sign in to leave a comment.