This topic created in 2047 days ago, the information mentioned may be changed or developed.
InSerttTime 字段是 datetime 类型
比如，要 SELECT 出 InSerttTime 字段是"2020-03-15 XX:43:XX",要找出当天 43 分的所有字段内容
如果是指定时、秒，而不指定日期呢？
 | 1 zvcs Sep 20, 2020 via iPhone ... where minute （ InSerttTime ）=‘4’ |
 | 2 coderteddy Sep 20, 2020 有 format 不会用吗，兄弟 |
 | 4 aguesuka Sep 20, 2020 在意性能就单独一个字段存。 不在意就转字符串比较 |
 | 6 virusdefender Sep 20, 2020 https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_extract mysql> SELECT EXTRACT(DAY_MINUTE FROM '2019-07-02 01:02:03'); -> 20102 |
 | 7 ccalywm Sep 21, 2020 select InSerttTime from table where InSerttTime regexp '2020-03-15 XX:43:' |
 | 8 CodeCodeStudy Sep 21, 2020 先 SELECT id FROM table_name WHERE InSerttTime >= '2020-03-15' AND InSerttTime < '2020-03-16'; 得到所有符合条件的主键 id，假设得到的是 1,2,3，然后再 SELECT * FROM table_name WHERE id IN (1,2,3); |
Select Language