Insert current date in mysql

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

Similar codes

0 vote289 views1 answer
Duplix print in Smartforms
SQL
5 votes261 views1 answer
How to check nls timestamp format in oracle
SQL
0 vote305 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
0 vote273 views1 answer
Luu ckeditor vao mysql
SQL
0 vote278 views2 answers
Insert into
SQL
0 vote257 views1 answer
Opensuse status MySQL
SQL
0 vote279 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote295 views1 answer
Enable outgoing remote MySQL access
SQL
0 vote279 views1 answer
Mysql sql select one day before
SQL
0 vote290 views1 answer
Get all employee of salary if more than in sql
SQL