PHP date()格式MySQL中插入datetime方法
作者:laozhang 时间:2024-05-13 09:51:39
当使用PHP在MySQL中编写查询时,它的适用性将基于MySQL本身进行检查。所以使用MySQL提供的默认日期和时间格式,即'YYYY-MM-DD'
例子:
ATE: YYYY-MM-DD
Example: 2019-01-28
DATETIME: YYYY-MM-DD HH:MI:SS
Example: 2019-01-28 23:50:30
TIMESTAMP: YYYY-MM-DD HH:MI:SS
Example: 2019-01-28 23:50:30
YEAR: YYYY or YY
用于创建DataBase的MySQL查询:
CREATE DATABASE Date_time_example;
示例1:用于创建数据库和表的PHP程序
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";
// 创建连接
$conn = mysqli_connect( $servername, $username, $password, $dbname );
// 检查连接
if ( !$conn ) {
die("Connection failed: " . mysqli_connect_error());
}
// 创建表的SQL查询
$sql = "CREATE TABLE date_test (
id INT AUTO_INCREMENT PRIMARY KEY,
created_at DATETIME
)";
if (mysqli_query($conn, $sql)) {
echo "Table date_test created successfully";
} else {
echo "Error creating table: " . mysqli_error($conn);
}
// 关闭连接
mysqli_close($conn);
输出:
Table date_test created successfully
示例2:将日期插入表中的PHP程序。
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";
// 创建连接
$conn = mysqli_connect( $servername, $username, $password, $dbname );
// 检查连接
if ( !$conn ) {
die("Connection failed: " . mysqli_connect_error());
}
// 用于向表中插入数据的SQL查询
$sql = "INSERT INTO date_test( created_at )
VALUES( '2019-01-28 12:39:16' );";
if (mysqli_query($conn, $sql)) {
echo "New record created successfully";
} else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
// 关闭连接
mysqli_close($conn);
输出:
New record created successfully
示例3:此示例用于显示在2019-01-28上创建的行。使用以下查询显示结果。created_at列不仅包含日期,还包含时间。所以它会显示错误信息。
SELECT * FROM date_test WHERE DATE( created_at ) = '2019-01-28';
<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";
//创建连接
$conn = mysqli_connect( $servername, $username, $password, $dbname );
// 检查连接
if ( !$conn ) {
die("Connection failed: " . mysqli_connect_error());
}
//SQL查询
$sql = "SELECT * FROM date_test
WHERE DATE(created_at) = '2019-01-28'";
$result = mysqli_query( $conn, $sql );
if ($result) {
echo $result; //打印查询结果
}
else {
echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}
// 关闭连接
mysqli_close($conn);
输出:
id created_at
1 2019-01-28 12:39:16
要从DATETIME值获取年,季度,月,周,日,小时,分钟和秒,请使用以下语句中显示的函数:
HOUR(@dt),MINUTE(@dt),SECOND(@dt) ),DAY(@dt),WEEK(@dt),MONTH(@dt),QUARTER(@dt),YEAR(@dt);
标签:PHP,date()
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
SqlServer 在事务中获得自增ID的实例代码
2024-01-24 19:27:36
Python爬取百度翻译实现中英互译功能
2023-04-29 08:32:26
![](https://img.aspxhome.com/file/2023/3/90763_0s.jpg)
python从入门到实践之字典
2023-05-11 22:20:17
详解Python操作Excel之openpyxl
2021-10-13 05:13:21
浅析python中while循环和for循环
2022-10-26 18:56:18
Python字典推导式将cookie字符串转化为字典解析
2023-02-26 14:22:17
python实现从字符串中找出字符1的位置以及个数的方法
2023-06-13 20:36:10
详解Python迭代和迭代器
2023-04-30 23:31:13
django实现模板中的字符串文字和自动转义
2023-10-18 16:49:46
关于Vue3中的响应式原理
2024-04-30 10:29:23
![](https://img.aspxhome.com/file/2023/4/130174_0s.png)
详解python读取matlab数据(.mat文件)
2021-03-04 19:29:29
![](https://img.aspxhome.com/file/2023/1/89331_0s.png)
Python基于文件内容实现查找文件功能
2022-04-13 11:17:47
![](https://img.aspxhome.com/file/2023/4/109904_0s.jpg)
php关于array_multisort多维数组排序的使用说明
2023-09-07 08:13:27
uniapp路由uni-simple-router实例详解
2023-09-24 21:27:04
Python如何把Spark数据写入ElasticSearch
2021-06-28 20:07:46
Python如何使用PIL Image制作GIF图片
2023-08-24 22:42:17
![](https://img.aspxhome.com/file/2023/5/105435_0s.jpg)
Python参数传递对象的引用原理解析
2023-04-23 18:33:57
Python基于Serializer实现字段验证及序列化
2023-07-19 21:50:36
网马解密大讲堂——网马解密中级篇(Freshow工具使用方法)
2009-09-16 15:09:00
![](https://img.aspxhome.com/file/UploadPic/20099/16/freshow-13s.jpg)
Python利用matplotlib.pyplot.boxplot()绘制箱型图实例代码
2022-11-18 05:08:26
![](https://img.aspxhome.com/file/2023/3/80403_0s.png)