In this article, we will cover some interesting operations involving date and time data values in SQL. The SQL standard specifies the following date and time-related data types that must be present in relational databases: date, time, timestamp and interval.
- date: Represents a single day. Example 15/12/2018
- time: Represents the time with hour, minutes, seconds. Example 09:14:30
- timestamp: Represents a point in the timeline. Example 2018-12-15 09:14:30
- interval: Repres...