option
DEFAULT
ON UPDATE
date
time
datetime
timestamp
year
interval
DBMS and version
Types
MySQL 5.7
NOT SUPPORTED
PostgreSQL 9.5
INTERVAL
SQL Server 2014
NOT SUPPORTED
Oracle 11g
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND |
interval A to B