[MDEV-17776] CAST(x AS INTERVAL DAY_SECOND(N)) Created: 2018-11-20 Updated: 2018-11-21 Resolved: 2018-11-20 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Temporal Types |
| Fix Version/s: | 10.4.1 |
| Type: | Task | Priority: | Major |
| Reporter: | Alexander Barkov | Assignee: | Alexander Barkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
To write mtr tests easier, we'll add CAST(x AS INTERVAL DAY_SECOND(N)).
It will be helpful to write tests with functions that now understand long time intervals:
So in this query:
it will be clear how the day and the hour value are calculated. |