Answers for "date type mysql"

insert date sql

INSERT INTO FOO (xpto) VALUES(TO_DATE('17/12/2015', 'DD/MM/YYYY'));

Posted by: Guest on June-29-2020

time data type in mysql

Data Type	“Zero” Value
DATE		'0000-00-00'
TIME		'00:00:00'
DATETIME	'0000-00-00 00:00:00'
TIMESTAMP	'0000-00-00 00:00:00'
YEAR		0000

Posted by: Guest on August-23-2021

time data format for mysql

hh:ii:ss

Posted by: Guest on December-03-2020

Code answers related to "date type mysql"