DATE VALUE DISPLAYED NOT AS ENTERED
i build the sales table as below using mysql but the date value that i entered is not the one displayed on the database.
What is the problem? Please help.
mysql> CREATE TABLE SALES
-> (
-> SALES_ID INT NOT NULL,
-> SALES_DATE TIME NOT NULL,
-> PRIMARY KEY(SALES_ID),
-> );
Query OK, 0 rows affected (0.02 sec)
mysql> INSERT INTO SALES VALUES(10001,'1998-08-18');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO SALES VALUES(10002,'1999-03-30');
Query OK, 1 row affected (0.01 sec)
mysql> SELECT * FROM SALES;
+----------+------------+
| SALES_ID | SALES_DATE |
+----------+------------+
| 10001 | 00:00:00 |
| 10002 | 00:00:00 |
+----------+------------+
2 rows in set (0.00 sec)
|
