Bug #84704 The month in the output of a timestamp in MySQL shell is offset by 1.

• Submitted: 29 Jan 2017 11:02
• Modified: 30 Jan 2017 8:10
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Document Store: MySQL Shell
• Severity: S2 (Serious)
• Version: 1.0.5
• OS: Any
• CPU Architecture: Any
• Tags: date, NOW, timestamp

[29 Jan 2017 11:02] Daniël van Eeden

Description:
The date as reported by now() is offset by one month.

How to repeat:
mysql-sql> select now(), sysdate(), CURRENT_TIMESTAMP, concat(now(),''), CONVERT(CURRENT_TIMESTAMP USING latin1);
+---------------------+---------------------+---------------------+---------------------+-----------------------------------------+
| now()               | sysdate()           | CURRENT_TIMESTAMP   | concat(now(),'')    | CONVERT(CURRENT_TIMESTAMP USING latin1) |
+---------------------+---------------------+---------------------+---------------------+-----------------------------------------+
| 2017-02-29 12:00:50 | 2017-02-29 12:00:50 | 2017-02-29 12:00:50 | 2017-01-29 12:00:50 | 2017-01-29 12:00:50                     |
+---------------------+---------------------+---------------------+---------------------+-----------------------------------------+
1 row in set (0.00 sec)

[29 Jan 2017 11:05] Daniël van Eeden

Set to S2

[30 Jan 2017 8:10] MySQL Verification Team

Hello Daniël,

Thank you for the report.
Verified as described.

Thanks,
Umesh