blocks|key|1017535|text|如果您希望存储当前时间，只需使用MYSQL的函数即可。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1017536|mysql_query("INSERT+INTO+`table`+(`dateposted`)+VALUES+(now())");|code-block|syntax|javascript|1017537|如果您需要使用PHP来完成此操作，请将其格式设置为Y-m-d+H:i:s，因此尝试|offset|length|style|CODE|1017538|$date+=+date('Y-m-d+H:i:s');
mysql_query("INSERT+INTO+`table`+(`dateposted`)+VALUES+('$date')");|1017539|entityMap^0|0|0|P|B|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

If you're looking to store the current time just use MYSQL's functions.

<pre><code>mysql_query("INSERT INTO `table` (`dateposted`) VALUES (now())");
</code></pre>

If you need to use PHP to do it, the format it <code>Y-m-d H:i:s</code> so try

<pre><code>$date = date('Y-m-d H:i:s');
mysql_query("INSERT INTO `table` (`dateposted`) VALUES ('$date')");
</code></pre>

blocks|key|1760961|text|试试这个吧|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1760962|$date+=+date('Y-m-d+H:i:s');|code-block|syntax|javascript|1760963|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this instead

<pre><code>$date = date('Y-m-d H:i:s');
</code></pre>

blocks|key|5055816|text|你可以使用CURRENT_TIMESTAMP，mysql函数|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5055817|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

you can use CURRENT_TIMESTAMP, mysql function

blocks|key|5055798|text|NOW()用于在MySQL表中插入当前日期和时间。所有数据类型为DATETIME,+DATE,+TIME+&+TIMESTAMP的字段都可以很好地使用此函数。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5055799|YYYY-MM-DD+HH:mm:SS|5055800|演示：|5055801|下面的代码显示了NOW()的用法|5055802|INSERT+INTO+auto_ins
(MySQL_Function,+DateTime,+Date,+Time,+Year,+TimeStamp)
VALUES
(“NOW()”,+NOW(),+NOW(),+NOW(),+NOW(),+NOW());|code-block|syntax|javascript|5055803|entityMap^0|0|5|W|W|0|0|0|8|5|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]|$9|V|A|W|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|X|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|Y|8|@]|D|@]|E|$]]|$1|J|3|K|5|6|7|Z|8|@$9|10|A|11|B|C]]|D|@]|E|$]]|$1|L|3|M|5|N|7|12|8|@]|D|@]|E|$O|P]]|$1|Q|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|R|$]]

<code>NOW()</code> is used to insert the current date and time in the MySQL table. All fields with datatypes <code>DATETIME, DATE, TIME &amp; TIMESTAMP</code> work good with this function.

YYYY-MM-DD HH:mm:SS

Demonstration:

Following code shows the usage of <code>NOW()</code>

<pre><code>INSERT INTO auto_ins
(MySQL_Function, DateTime, Date, Time, Year, TimeStamp)
VALUES
(“NOW()”, NOW(), NOW(), NOW(), NOW(), NOW());
</code></pre>

blocks|key|1755543|text|将名为dateposted的列的type设置为DATETIME，然后运行以下查询：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1755544|INSERT+INTO+table+(`dateposted`)+VALUES+(CURRENT_TIMESTAMP)|code-block|syntax|javascript|1755545|entityMap^0|3|A|G|4|N|8|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]|$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|U|8|@]|D|@]|E|$]]]|L|$]]

set the <code>type</code> of column named <code>dateposted</code> as <code>DATETIME</code> and run the following query:

<pre><code>INSERT INTO table (`dateposted`) VALUES (CURRENT_TIMESTAMP)
</code></pre>

blocks|key|1760957|text|"datetime“期望日期格式如下:+YYYY-MM-DD+HH:MM:SS|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1760958|因此，在插入时，请将日期设置为这样的格式。|1760959|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/datetime.html^0|1|8|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

"<a href="http://dev.mysql.com/doc/refman/5.1/en/datetime.html" rel="nofollow">datetime</a>" expects the date to be formated like this: YYYY-MM-DD HH:MM:SS

so format your date like that when you are inserting.

blocks|key|740707|text|+++++<?php+$date=+date("Y-m-d");
$time=date("H:m");
$datetime=$date."T".$time;
mysql_query(INSERT+INTO+table+(`dateposted`)+VALUES+($datetime));
?>

<form+action="form.php"+method="get">
<input+type="datetime-local"+name="date"+value="<?php+echo+$datetime;+?>">
<input+type="submit"+name="submit"+value="submit">|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|740708|​|unstyled|740709|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|J|8|@]|9|@]|A|$]]|$1|G|3|-4|5|F|7|K|8|@]|9|@]|A|$]]]|H|$]]

<pre><code> &lt;?php $date= date("Y-m-d");
$time=date("H:m");
$datetime=$date."T".$time;
mysql_query(INSERT INTO table (`dateposted`) VALUES ($datetime));
?&gt;

&lt;form action="form.php" method="get"&gt;
&lt;input type="datetime-local" name="date" value="&lt;?php echo $datetime; ?&gt;"&gt;
&lt;input type="submit" name="submit" value="submit"&gt;
</code></pre>

blocks|key|1017709|text|如果你从PHP传递日期，你可以使用STR_TO_DATE()+mysql函数的任何格式。让我们相信您正在通过html表单插入日期。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1017710|$Tdate+=+"'".$_POST["Tdate"]."'"+;++++//+++10/04/2016
$Tdate+=+"STR_TO_DATE(".$Tdate.",+'%25d/%25m/%25Y')"++;++
mysql_query("INSERT+INTO+`table`+(`dateposted`)+VALUES+('$Tdate')");|code-block|syntax|javascript|1017711|dateposted类型应为mysql+date类型。否则mysql将添加00:00:00|1017712|在某些情况下，您最好将日期和时间一起插入到数据库中，这样您就可以用小时和秒进行计算。()。|1017713|$Tdate=date('Y/m/d+H:i:s')+;+//+this+to+get+current+date+as+text+.
$Tdate+=+"STR_TO_DATE(".$Tdate.",+'%25d/%25m/%25Y+%25H:%25i:%25s')"++;++|1017714|entityMap^0|H|D|0|0|0|A|K|4|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@$9|T|A|U|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|M|3|N|5|6|7|11|8|@]|D|@]|E|$]]|$1|O|3|P|5|H|7|12|8|@]|D|@]|E|$I|J]]|$1|Q|3|-4|5|6|7|13|8|@]|D|@]|E|$]]]|R|$]]

If you Pass date from PHP you can use any format using <code>STR_TO_DATE()</code> mysql function .
Let conseder you are inserting date via html form 

<pre><code>$Tdate = "'".$_POST["Tdate"]."'" ; // 10/04/2016
$Tdate = "STR_TO_DATE(".$Tdate.", '%d/%m/%Y')" ; 
mysql_query("INSERT INTO `table` (`dateposted`) VALUES ('$Tdate')");
</code></pre>

The <code>dateposted</code> should be mysql <code>date</code> type . or mysql will adds 00:00:00 
in some case You better insert date and time together into DB so you can do calculation with hours and seconds . () .

<pre><code>$Tdate=date('Y/m/d H:i:s') ; // this to get current date as text .
$Tdate = "STR_TO_DATE(".$Tdate.", '%d/%m/%Y %H:%i:%s')" ; 
</code></pre>

blocks|key|1761099|text|让它变得更简单、更高效的最好方法是：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1761100|CREATE+TABLE+table_name+(
field1,
..
..
time_updated+timestamp+default+current_timestamp
)|code-block|syntax|javascript|1761101|现在，当您在表中插入一行时，您可以跳过此字段(time_updated)，因为它将以当前时间作为默认值进行填充|offset|length|style|CODE|1761102|entityMap^0|0|0|N|C|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

The best way to make it easier and efficient is this:

<pre><code>CREATE TABLE table_name (
field1,
..
..
time_updated timestamp default current_timestamp
)
</code></pre>

Now, when you insert a row into table, you can skip this field (<code>time_updated</code>) as it will fill with current time as default value

blocks|key|5055980|text|只需与您的时区一起使用：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5055981|date_default_timezone_set('Asia/Kolkata');++++++
$date=date("Y/m/d+h:i:sa");|code-block|syntax|javascript|5055982|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Just use with your timezone : 

<pre><code>date_default_timezone_set('Asia/Kolkata'); 
$date=date("Y/m/d h:i:sa");
</code></pre>

blocks|key|5056004|text|$date+=+date('Y-m-d+H:i:s')；类型：'datetime‘非常适合我，因为我想打印整个日期和时间戳。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5056005|$date+=+date('Y-m-d+H:i:s')；$stmtc->bindParam(2，$date)；|5056006|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

$date = date('Y-m-d H:i:s');
with the type: 'datetime' worked very good for me as i wanted to print whole date and timestamp..

$date = date('Y-m-d H:i:s');
$stmtc->bindParam(2,$date);

blocks|key|1755612|text|这取决于您为db表设置的数据类型。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1755613|DATETIME+(数据类型)|1755614|MYSQL|1755615|INSERT+INTO+t1+(dateposted)+VALUES+(+NOW()+)
//+This+will+insert+date+and+time+into+the+col.+Do+not+use+quote+around+the+val|code-block|syntax|javascript|1755616|PHP|1755617|$dt+=+date('Y-m-d+h:i:s');
INSERT+INTO+t1+(dateposted)+VALUES+(+'$dt'+)
//+This+will+insert+date+into+the+col+using+php+var.+Wrap+with+quote.|1755618|日期(数据类型)|1755619|1755620|INSERT+INTO+t1+(dateposted)+VALUES+(+NOW()+)
//+Yes,+you+use+the+same+NOW()+without+the+quotes.
//+Because+your+datatype+is+set+to+DATE+it+will+insert+only+the+date|1755621|1755622|$dt+=+date('Y-m-d');
INSERT+INTO+t1+(dateposted)+VALUES+(+'$dt'+)
//+This+will+insert+date+into+the+col+using+php+var.|1755623|时间(数据类型)|1755624|1755625|INSERT+INTO+t1+(dateposted)+VALUES+(+NOW()+)
//+Yes,+you+use+the+same+NOW()+as+well.+
//+Because+your+datatype+is+set+to+TIME+it+will+insert+only+the+time|1755626|1755627|$dt+=+date('h:i:s');
INSERT+INTO+t1+(dateposted)+VALUES+(+'$dt'+)
//+This+will+insert+time.|1755628|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|18|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|19|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|1B|8|@]|9|@]|A|$I|J]]|$1|O|3|P|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Q|3|E|5|6|7|1D|8|@]|9|@]|A|$]]|$1|R|3|S|5|H|7|1E|8|@]|9|@]|A|$I|J]]|$1|T|3|L|5|6|7|1F|8|@]|9|@]|A|$]]|$1|U|3|V|5|H|7|1G|8|@]|9|@]|A|$I|J]]|$1|W|3|X|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Y|3|E|5|6|7|1I|8|@]|9|@]|A|$]]|$1|Z|3|10|5|H|7|1J|8|@]|9|@]|A|$I|J]]|$1|11|3|L|5|6|7|1K|8|@]|9|@]|A|$]]|$1|12|3|13|5|H|7|1L|8|@]|9|@]|A|$I|J]]|$1|14|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|15|$]]

It depends on what datatype you set for your db table.
<h3>DATETIME (datatype)</h3>
MYSQL
<pre><code>INSERT INTO t1 (dateposted) VALUES ( NOW() )
// This will insert date and time into the col. Do not use quote around the val
</code></pre>
PHP
<pre><code>$dt = date('Y-m-d h:i:s');
INSERT INTO t1 (dateposted) VALUES ( '$dt' )
// This will insert date into the col using php var. Wrap with quote.
</code></pre>
<h3>DATE (datatype)</h3>
MYSQL
<pre><code>INSERT INTO t1 (dateposted) VALUES ( NOW() )
// Yes, you use the same NOW() without the quotes.
// Because your datatype is set to DATE it will insert only the date
</code></pre>
PHP
<pre><code>$dt = date('Y-m-d');
INSERT INTO t1 (dateposted) VALUES ( '$dt' )
// This will insert date into the col using php var.
</code></pre>
<h3>TIME (datatype)</h3>
MYSQL
<pre><code>INSERT INTO t1 (dateposted) VALUES ( NOW() )
// Yes, you use the same NOW() as well. 
// Because your datatype is set to TIME it will insert only the time
</code></pre>
PHP
<pre><code>$dt = date('h:i:s');
INSERT INTO t1 (dateposted) VALUES ( '$dt' )
// This will insert time.
</code></pre>

blocks|key|739879|text|我相信，你需要像下面这样改变你的代码以及你的数据库文件类型。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|739880|mysql_query("INSERT+INTO+table+(`dateposted`)+VALUES+($datetime)");|code-block|syntax|javascript|739881|希望，将完美地工作。|739882|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

I believe, you need to change your code little bit like follows alongside with your database filed type. 

<pre><code>mysql_query("INSERT INTO table (`dateposted`) VALUES ($datetime)");
</code></pre>

Hope, will work perfectly.

blocks|key|1761113|text|使用这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1761114|$date+=+date('m/d/Y+h:i:s',+time());|offset|length|style|CODE|1761115|然后在MYSQL中|1761116|type=varchar|1761117|则日期和时间将被成功插入|1761118|entityMap^0|0|0|10|0|0|0|C|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@$D|R|E|S|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@$D|V|E|W|F|G]]|9|@]|A|$]]|$1|L|3|M|5|6|7|X|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|O|$]]

use this

<code>$date = date('m/d/Y h:i:s', time());</code>

and then 
in MYSQL do

<code>type=varchar</code>

then date and time will be successfully inserted

blocks|key|1761089|text|尝尝这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1761090|$('#datepicker2').datepicker('setDate',+new+Date('<?=$value->fecha_final?>'));+|code-block|syntax|javascript|1761091|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try this

<pre><code>$('#datepicker2').datepicker('setDate', new Date('&lt;?=$value-&gt;fecha_final?&gt;')); 
</code></pre>

I'm having problems getting the date inserted properly into my database.

<pre><code>$date = date('m/d/Y h:i:s', time());
</code></pre>

I use this format, and, it echoes out correctly, however, when, I insert

<pre><code>mysql_query("INSERT INTO table 
(dateposted) 
VALUES ('$date')");
</code></pre>

it doesn't appear to work successfully, and, the time remains 00:00:00
If you could find the solution that would be great, thanks.

Insert current date in datetime format mySQL

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我在将日期正确插入我的数据库时遇到了问题。$date = date('m/d/Y h:i:s', time());我使用这种格式，并且，它正确地回显，但是，当我插入mysql_query("INSERT INTO table (dateposted) VALUES ('$date')");它似乎没有成功工作，如果你能找到很好的解决方案，时间仍然是00:00:00，谢谢。

问以日期时间格式mySQL插入当前日期
EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问以日期时间格式mySQL插入当前日期EN

回答 15

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问以日期时间格式mySQL插入当前日期
EN