The following table lists the date and time data types available in MySQL and shows whether or not they are available in Oracle, PostgreSQL, and SQL Server:
NOTE: The size allowances on Oracle, PostgreSQL, and SQL Server may be different even if the data type name is the same.
| Date and time data types in MySQL | Also available in | ||
| Data Type | SQL Server | PostgreSQL | Oracle |
| DATE | Yes | Yes | Yes |
| TIME | Yes | Yes | No |
| DATETIME | No | No | No |
| TIMESTAMP | Yes | Yes | Yes |
| YEAR | No | No | No |
The preceding table lists the date and time data types available in MySQL and shows whether or not they are available in Oracle, PostgreSQL, and SQL Server.