DATETIME: Combination of DATE and TIME in the form '2003-12-31 23:59:59' (8 bytes) : DateTime « Data Type « SQL / MySQL






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

DATETIME: Combination of DATE and TIME in the form '2003-12-31 23:59:59' (8 bytes)

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

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








Related examples in the same category

1.Datetime as column type
2.Order by DATETIME
3.Produce a time-of-day summary for records
4.You can replace the hyphen (-) and colon (:) characters with any other punctuation character without affecting