Time Intervals lubridate R.PNG
|
Duplicate |
|||
| is duplicated by | MDEV-12513 | INTERVAL data type | Open |
[MDEV-13088] SUGGESTION: New Data Type: Time Intervals Created: 2017-06-14 Updated: 2021-11-17 Resolved: 2017-06-14 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data types, Temporal Types |
| Fix Version/s: | N/A |
| Type: | Task | Priority: | Major |
| Reporter: | Juan Telleria | Assignee: | Unassigned |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | timestamp | ||
| Attachments: |
Time Intervals lubridate R.PNG
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
I would like to suggest that MariaDB 10.3 implements a new data type to differentiate from SQL Server, PostgreSQL and Oracle: Time Intervals. This New Data would be really valuable for doing JOINs between tables which have a Temporal Overlap between Events, and would suppose a disruptive innovation in the RDBMS industry. In R package lubridate, Time Intervals are defined as follows: Hope my suggestion is useful. Kind regards, |
| Comments |
| Comment by Sergei Golubchik [ 2017-06-14 ] |
|
Is that a duplicate of MDEV-12513? |
| Comment by Juan Telleria [ 2017-06-14 ] |
|
Yes, it is a duplicate. I added some valuable comments on MDEV-12513 in order to continue with such development. |