blocks|key|916150|text|在SQL查询中编写日期时，您将其作为字符串编写；您必须对准备好的语句执行相同的操作，并使用PDO::PARAM_STR，就像您在建议的代码部分中所做的那样。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|916151|对于“时间戳”，如果“时间戳”是指：|916152|PHP时间戳数据类型:它是相同的，您将把它作为一个string|916153|The+PHP+Unix时间戳传递，它是一个整数:您将向它传递一个int.|unordered-list-item|916154|916155|entityMap^0|19|E|0|0|P|6|0|X|3|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|T|8|@$9|U|A|V|B|C]]|D|@]|E|$]]|$1|J|3|K|5|L|7|W|8|@$9|X|A|Y|B|C]]|D|@]|E|$]]|$1|M|3|-4|5|6|7|Z|8|@]|D|@]|E|$]]|$1|N|3|-4|5|6|7|10|8|@]|D|@]|E|$]]]|O|$]]

When writing a date in an SQL query, you are writing it as a string; you have to do the same with prepared statements, and use <code>PDO::PARAM_STR</code>, like you did in the portion of code you proposed.

And for the "timestamp", if by "timestamp" you mean:

<ul>
<li>The MySQL timestamp data-type: it's the same, you'll pass it as a <code>string</code></li>
<li>The PHP Unix timestamp, which is an integer: you'll pass it an <code>int</code>.</li>
</ul>

blocks|key|1303318|text|只需使用php+date函数创建日期，就可以解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1303319|$handle->execute(array(":date"=>date("Y-m-d+H:i:s",+strtotime($date)),+PDO::PARAM_STR));|code-block|syntax|javascript|1303320|1303321|编辑:请注意，strtotime+(http://php.net/manual/en/function.strtotime.php)并不能处理所有类型的日期格式。|blockquote|offset|length|style|CODE|1303322|1303323|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.strtotime.php^0|0|0|0|7|9|I|1B|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Y|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@$K|11|L|12|M|N]]|9|@$K|13|L|14|1|15]]|A|$]]|$1|O|3|-4|5|6|7|16|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|Q|$R|$5|S|T|U|A|$V|W]]]]

Simply creating the date using php date function should fix this issue for you.

<pre><code>$handle-&gt;execute(array(":date"=&gt;date("Y-m-d H:i:s", strtotime($date)), PDO::PARAM_STR));
</code></pre>

<blockquote>
 Edit: Please note though, that <code>strtotime</code>
 (<a href="http://php.net/manual/en/function.strtotime.php" rel="nofollow noreferrer">http://php.net/manual/en/function.strtotime.php</a>) can't handle every
 kind of date formats.
</blockquote>

blocks|key|916138|text|不是的。将date视为字符串。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|916139|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|$]]

blocks|key|2711980|text|在DateTime中正确存储RDBMS值(作为字符串)的完整部分：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2711981|/**+@const+string+app_date_format+expected+date+format+in+the+PHP+domain+(Swiss)+*/
define(+'app_date_format',+'d.m.Y'+);+

/**+@var+PDOConnection+$db+*/
$db+=+new+\PDO(+$dsn,+$db_user,+$db_pass,+$db_options+);

/**+@var+DateTime+$date+*/
$date+=+\DateTime::createFromFormat(+app_date_format,+'30.11.2020'+);

$stmt+=+$db->+prepare(
++++"UPDATE+`test`
++++SET+`test_date`+=+STR_TO_DATE(:date,+'%25Y-%25m-%25d+%25H:%25i:%25s'+)
++++WHERE+`test`.`test_id`+=+:id"
);

$id+=+1;
$stmt->bindValue(+':id',+$id+);
$stmt->bindValue(+':date',+$date->+format(+'Y-m-d+H:i:s'));
$stmt->execute()+or+die(+$stmt->+errorInfo()[2]+);|code-block|syntax|javascript|2711982|使用PHP7.4.25；MariaDB+10.6.4测试|2711983|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|$]]

A complete section to properly store a DateTime value (as a string) in a RDBMS:
<pre><code>/** @const string app_date_format expected date format in the PHP domain (Swiss) */
define( 'app_date_format', 'd.m.Y' ); 

/** @var PDOConnection $db */
$db = new \PDO( $dsn, $db_user, $db_pass, $db_options );

/** @var DateTime $date */
$date = \DateTime::createFromFormat( app_date_format, '30.11.2020' );

$stmt = $db-&gt; prepare(
 &quot;UPDATE `test`
 SET `test_date` = STR_TO_DATE(:date, '%Y-%m-%d %H:%i:%s' )
 WHERE `test`.`test_id` = :id&quot;
);

$id = 1;
$stmt-&gt;bindValue( ':id', $id );
$stmt-&gt;bindValue( ':date', $date-&gt; format( 'Y-m-d H:i:s'));
$stmt-&gt;execute() or die( $stmt-&gt; errorInfo()[2] );
</code></pre>
Tested with PHP 7.4.25; MariaDB 10.6.4

blocks|key|1303400|text|您必须将日期视为字符串，但您可以创建一个函数，在将其作为参数传递之前检查它是否为有效日期。如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1303401|function+checkValidDate($date,+$format+=+"dd-mm-yyyy"){
++++++++++++if($format+===+"dd-mm-yyyy"){
++++++++++++$day+=+(int)+substr($date,0,2);
++++++++++++$month+=+(int)+substr($date,+3,2);
++++++++++++$year+=+(int)+substr($date,+6,4);

++++++++}else+if($format+===+"yyyy-mm-dd"){
++++++++++++$day+=+(int)+substr($date,8,2);
++++++++++++$month+=+(int)+substr($date,+5,2);
++++++++++++$year+=+(int)+substr($date,+0,4);
++++++++}

++++++++return+checkdate($month,+$day,+$year);
}|code-block|syntax|javascript|1303402|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|$]]

You have to treat the date as string, but you can create a function to check if is a valid date before pass it as a param.
Like this:

<pre><code>function checkValidDate($date, $format = "dd-mm-yyyy"){
 if($format === "dd-mm-yyyy"){
 $day = (int) substr($date,0,2);
 $month = (int) substr($date, 3,2);
 $year = (int) substr($date, 6,4);

 }else if($format === "yyyy-mm-dd"){
 $day = (int) substr($date,8,2);
 $month = (int) substr($date, 5,2);
 $year = (int) substr($date, 0,4);
 }

 return checkdate($month, $day, $year);
}
</code></pre>

blocks|key|919023|text|这对我很有效。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|919024|//MS+SQL
$sql+=+"UPDATE+my_table+SET+current_date+=+GETDATE()+WHERE+id+=+43";
$statement+=+$pdo->prepare+($sql);
//$statement->bindParam+(":date",+strtotime+(date+("Y-m-d+H:i:s")),+PDO::PARAM_STR);
$statement->execute+();|code-block|syntax|javascript|919025|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|$]]

This worked for me.

<pre><code>//MS SQL
$sql = "UPDATE my_table SET current_date = GETDATE() WHERE id = 43";
$statement = $pdo-&gt;prepare ($sql);
//$statement-&gt;bindParam (":date", strtotime (date ("Y-m-d H:i:s")), PDO::PARAM_STR);
$statement-&gt;execute ();
</code></pre>

Does some <code>PDO::PARAM_???</code> exist which can be used for dates or timestamps?
Sample code:
<pre><code>$sql = &quot;UPDATE my_table SET current_date = :date WHERE id = 43&quot;;
$statement = $pdo-&gt;prepare ($sql);
$statement-&gt;bindValue (&quot;:date&quot;, strtotime (date (&quot;Y-m-d H:i:s&quot;)), PDO::PARAM_STR);
$statement-&gt;execute ();
</code></pre>

PDO::PARAM for dates?

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

是否存在可用于日期或时间戳的PDO::PARAM_???？示例代码：$sql = "UPDATE my_table SET current_date = :date WHERE id = 43";$statement = $pdo->prepare ($sql);$statement->bindValue (":date", strtotime (date ("Y-m-d H:i:s")), PD

问PDO::PARAM for date？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PDO::PARAM for date？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PDO::PARAM for date？
EN