mysql 查询 根据时分秒取数据 比如 取 时间为 8点半的 dateformat 时间函数转换
2023-09-11 14:14:38 时间
date_format(date,'%H') = 8 and date_format(date,'%i') = 30
![](https://img2018.cnblogs.com/blog/856389/201903/856389-20190305162430535-1476612776.png)
SELECT * FROM `t_pda_trucklog` WHERE
DATE_FORMAT(operatetime,'%H') = 9 AND DATE_FORMAT(operatetime,'%i') = 42 AND DATE_FORMAT(operatetime,'%s') = 12
http://www.w3school.com.cn/sql/func_date_format.asp
相关文章
- Error connecting to database [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)]
- 【Mysql 学习】mysql 字符集
- 【MySQL】如何获取自增id
- 【MySQL】常见的mysql 进程state
- linux - mysql 异常:MySQL Daemon failed to start.
- linux - mysql - 卸载:RPM包安装方式的MySQL卸载
- Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
- MYSQL避免全表扫描__如何查看sql查询是否用到索引(mysql)
- Mysql行列转换sql语句
- Hadoop sqoop从MySQL导入数据到HDFS
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- Starting MySQL. ERROR! The server quit without updating PID file (/data/mysql/mysql.pid).
- Python MySQL - mysql-connector 驱动
- Node.jsでMySQLを使うメモ
- peewee.ImproperlyConfigured: MySQL driver not installed!
- mysql 教程
- mysql sql语句大全(MySQL语句 整理一)
- MySQL技术内幕读书笔记(一)——Mysql体系结构和存储引擎
- 如何实现MySQL表数据随机读取?从mysql表中读取随机数据
- Mysql报错:Can't connect to local MySQL server through socket '/tmp/mysql.sock'
- 常用命令之mysql命令
- 【MySQL】mysql查询语句大总结_Unit04
- MySQL报错Column count of mysql.user is wrong. Expected 43, found 42. Created with MySQL 50568, now run
- 【Mysql异构实时同步Oracle】OGG12异构同步mysql到oracle(windows mysql实时同步数据到linux oracle)详细文档