mysql insert value date
UPDATE personal set birthday = STR_TO_DATE('1-01-2012', '%d-%m-%Y') where birthday IS NULL;
Source: stackoverflow.com
insert current date in mysql
INSERT INTO my_table (last_updated) VALUES(NOW()); INSERT INTO my_table (last_updated) VALUES(sysdate); -- Oracle INSERT INTO my_table (last_updated) VALUES(getdate()); -- SQL Server