当前位置:Gxlcms > 数据库问题 > MySQL获取对应时间

MySQL获取对应时间

时间:2021-07-01 10:21:17 帮助过:21人阅读

二、查询当前时间包含年月日时分秒

  1. <span style="color: rgba(0, 0, 0, 1)">SELECT NOW();
  2. SELECT SYSDATE();</span>

三、查询当天数据

  1. SELECT t1.* FROM user1 t1 WHERE TO_DAYS(t1.`birthday`) =<span style="color: rgba(0, 0, 0, 1)"> TO_DAYS(NOW());
  2. SELECT </span>* FROM user1 t1 WHERE t1.`birthday` BETWEEN DATE_FORMAT(NOW(), <span style="color: rgba(128, 0, 0, 1)">‘</span><span style="color: rgba(128, 0, 0, 1)">%Y-%m-%d 00:00:00</span><span style="color: rgba(128, 0, 0, 1)">‘</span><span style="color: rgba(0, 0, 0, 1)">) AND NOW();
  3. SELECT </span>* FROM user1 t1 WHERE DATE(t1.`birthday`) = CURDATE();

 

MySQL获取对应时间

标签:hda   div   mys   color   查询   code   bsp   rom   curd   

人气教程排行