[MDEV-5043] TIME('.123') and TIMESTAMP('.123') work differently Created: 2013-09-20  Updated: 2017-11-05

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.4, 5.5.33, 5.3.12
Fix Version/s: 10.2

Type: Bug Priority: Minor
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Unresolved Votes: 0
Labels: None


 Description    

mysql> select time('.123'), timestamp('.123');
 
+--------------+-------------------+
 
| time('.123') | timestamp('.123') |
 
+--------------+-------------------+
 
| 00:00:00.123 | NULL              |
 
+--------------+-------------------+

timestamp('.123') should return '0000-00-00 00:00:00.123' instead of NULL.
Generated at Thu Feb 08 07:01:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.