Date type value in the form '2003-12-31', range 1000-01-01 to 9999-12-31 (3 bytes) : Date « Data Type « SQL / MySQL






  1. SQL / MySQL
  2. Data Type
  3. Date

Date type value in the form '2003-12-31', range 1000-01-01 to 9999-12-31 (3 bytes)

  mysql>
mysql> CREATE TABLE employee(
    ->     id INT,
    ->     startDate DATE
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> drop table employee;
Query OK, 0 rows affected (0.00 sec)

mysql>








Related examples in the same category

1.To find the row with the most recent birth date, the query is similar, except that you sort in descending orde
2.Compare with Date value
3.How MySQL deals with incorrect date value
4.Date literal in where clause
5.Date value literal
6.Date type value inside in operator and subquery
7.Date calculation with variable
8.Date default value
9.Sorting by Calendar Day