SQL - DATES

While working with SQL Date datatypes, it is essential to know about the dates format when performing different operations on a database. Please note that, the datatype of column must be chosen while creating a new table in the database.

MySQL Date formats

The different data types available in MySQL for storing a date or a date/time value are mentioned below:

SQL Server Date formats

The different data types available in SQL Server for storing a date or a date/time value are mentioned below:

Example: Create a table with date datatype

The below mentioned SQL code creates a table called Employee which contains five columns: EmpID, Name, City, Age and Date of Joining.

CREATE TABLE Employee (
  EmpID INT NOT NULL,
  Name VARCHAR(255) NOT NULL,
  City VARCHAR(100),
  Age INT,
  [Date of Joining] DATE FORMAT 'YYYY-MM-DD'
);

This will create a empty table named Employee containing five columns as shown below:

Example: Working with date datatype

Consider a database table called Employee with the following records:

To fetch data of all employees present in the Employee table who joined the organization on '2019-05-25', the SQL code is:

SELECT * FROM Employee
WHERE [Date of Joining] = '2019-05-25';

This will produce the result as shown below:

Complete Date and Time Reference

• MySQL Data and Time Reference - See for a complete reference of all MySQL Date and Time functions.
• SQL Server Data and Time Reference - See for a complete reference of all SQL Server Date and Time functions.
• Oracle Data and Time Reference - See for a complete reference of all Oracle Date and Time functions.