Bug #103441 Ssl_server_not_(after|before) time format

• Submitted: 23 Apr 2021 9:19
• Modified: 23 Apr 2021 9:57
• Reporter: Iwo P
• Status: Verified
• Category: MySQL Server: Information schema
• Severity: S4 (Feature request)
• Version: 5.7, 8.0
• OS: Any
• CPU Architecture: Any

[23 Apr 2021 9:19] Iwo P

Description:
SSL certificate date for which the certificate is valid is instrumented with 
`Ssl_server_not_after` and `Ssl_server_not_before` status variables.

```
mysql> SHOW STATUS LIKE 'Ssl_server_not%';
+-----------------------+--------------------------+
| Variable_name         | Value                    |
+-----------------------+--------------------------+
| Ssl_server_not_after  | Apr 28 14:16:39 2025 GMT |
| Ssl_server_not_before | May  1 14:16:39 2015 GMT |
+-----------------------+--------------------------+
```

It would be very helpful and consistent with rest of the MySQL if the date would be presented in a DateTime format:

```
mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2021-04-23 11:18:56 |
+---------------------+
```

How to repeat:
-

Suggested fix:
Please use datetime.

[23 Apr 2021 9:57] MySQL Verification Team

Hello Iwo P,

Thank you for the feature request!

regards,
Umesh