SQL Date Data Types

SQL Tutorial » SQL Date Data Types

SQL SELECT DATE is used to retrieve a date from a database.

MySQL comes with the following data types for storing a date or a date/time value in the database:

• DATE - format YYYY-MM-DD example 2021-06-24
• DATETIME - format: YYYY-MM-DD HH:MI:SS 2021-06-24 11:34:46
• TIMESTAMP - format: YYYY-MM-DD HH:MI:SS 2021-06-24 11:34:46
• YEAR - format YYYY or YY 2021 or 21

SQL Server comes with the following data types for storing a date or a date/time value in the database:

• DATE - format YYYY-MM-DD example 2021-06-24
• DATETIME - format: YYYY-MM-DD HH:MI:SS 2021-06-24 11:34:46
• SMALLDATETIME - format: YYYY-MM-DD HH:MI:SS 2021-06-24 11:34:46
• TIMESTAMP - format: a unique number

Let's count the entire database (all rows in table) from "Users" first_name", "last_name", "country" and "email":

Related subjects:
SQL order by SQL where clause PHP select / view data Conect to MySQLi SQL insert into table

Tags: sql date: format, type, now, between, insert, convert, comparison, time, date type, format dd/mm/yyyy
How do you write a date in SQL query?
What is date command in SQL?
How do I insert date in YYYY-MM-DD format in SQL?
What is the data type of date in SQL?

Let's see the another query to get all the records after '2020-06-22' and before '2022-01-04' date.

If you want to compare the dates within the query, you should use BETWEEN operator to compare the dates.