更新时间:2023-01-30 18:48:22
To store dates or times in MySQL use date
, datetime
or timestamp
. I'd recommend the first two for most purposes.
To tell MySQL how to parse your date format use the STR_TO_DATE function. Here's an example:
CREATE TABLE table1 (`Date` Date);
INSERT INTO table1 (`Date`) VALUES (STR_TO_DATE('01/05/2010', '%m/%d/%Y'));
SELECT * FROM table1;
Date
2010-01-05
要将结果格式化为原始格式,请参见 DATE_FORMAT 函数.请注意,仅当您要使用默认格式以外的其他方式将其显示为字符串时,才需要对其进行格式化.
To format the results back into the original form look at the DATE_FORMAT function. Note that you only need to format it if you want to display it as a string using something other than the default format.