简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

mysql中时间日期 datetime字段保存日期出现0000-00-00

WBOY
Release： 2016-06-07 17:52:11
Original
2223 people have browsed it

如果大家注意一下datetime日期格式类型的话就应该可以不要问了，datetime日期必须是 2012-01-01 10:10:10 这种，否则就有可能出来0000-00-00

正确的php sql语句写法应该是： 

 

 代码如下 复制代码
$sql = "insert into table(datetime) values('".date("Y-m-d h:i:s",time())."')"; //datetime字段的类型为“datetime”，


注意后面要插入的数据是字符串要加“单引号”。
这样就没错了，时间日期类型插入数据库之前要格式化，否则就出现插入的全是0000-00-00的问题。

个人建义，大家保存时间时最好使用int类型保存time()生成的日期这样操作会更方便。

Related labels：
datetime date format
source：php.cn
Previous article：mysql启动提示 access denied for user root@localhost(using pa Next article：mysql float精度与范围总结
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
The query and formula form the entire table, with new columns, where the new columns are formulas involving other conditional column values EDIT: The formula should be the "value" column - the "value" column wi...
From 2024-04-06 21:23:40
0
2
530
Dynamically modify inline CSS styles in Javafx I'm trying to change the background image of a pane when the application is maximized. My ...
From 2024-04-06 20:57:16
0
1
487
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
MySQL: "Select text from... as <variable here or subquery>" I have the following table with the following data: id text language 1 german text german ...
From 2024-04-06 19:25:54
0
2
529
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！