[MDEV-21267] UNIX_TIMESTAMP(datetime'0000-00-00 00:00:00') returns NULL Created: 2019-12-10 Updated: 2020-02-14 Resolved: 2020-02-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | OTHER |
| Affects Version/s: | 10.4.6 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Alexander Matyushkin | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | datetime, need_feedback, timestamp | ||
| Environment: |
Windows 7 |
||
| Description |
|
When I call UNIX_TIMESTAMP(datetime'0000-00-00 00:00:00'), it returns NULL |
| Comments |
| Comment by Elena Stepanova [ 2020-01-13 ] |
|
It seems reasonable (and documented). What would you expect it to return instead? |