I want to customize the display format for YEAR columns to show only 'yyyy'.

in dataGrip… please

0

Hi,

Have you already tried configuring Custom Formats in File | Settings | Database | Data Editor and Viewer and setting Date to yyyy?

0

If I do that, it will globally set the format for all Date types to 'yyyy'. I only want to apply this specific 'YYYY' format to the dedicated MySQL YEAR column.

0
Assigning custom formats to specific table columns is not available. I have filed a feature request

https://youtrack.jetbrains.com/issue/DBE-24662

Please feel free to upvote and follow this ticket.
0

请先登录再写评论。