ok so i am working on a program that has a table of all the presidents and info on each of them. i tried to insert the date of their birthdays and deaths, but just got 0000-00-00 for a result when i went to see what the outcome looked like. help please
this is what i did to input it in.
INSERT INTO president_info (id, name, mname, last, bdate, ddate, yr_sworn, yr_left, party, home_town, state,vp) VALUES (1, 'George', 'n/a', 'Washington', 1732-02-22, 1799-12-14, 1789, 1796, 'Federalist', 'Westmoreland', 'Virginia', 'John Adams');
SELECT * FROM president_info;
+----+--------+-------+------------+------------+------------+----------+---------+-----------+--------------+----------+------------+
| id | name | mname | last | bdate | ddate | yr_sworn | yr_left | party | home_town | state | vp |
+----+--------+-------+------------+------------+------------+----------+---------+-----------+--------------+----------+------------+
| 1 | George | n/a | Washington | 0000-00-00 | 0000-00-00 | 0000 | 0000 | Federalist | Westmoreland | Virginia | John Adams |
+----+--------+-------+------------+------------+------------+----------+---------+-----------+--------------+----------+------------+
1 row in set (0.00 sec)