Shulou(Shulou.com)06/01 Report--

Access date time condition query

If the data type of the field is Date/Time, the data that is accurate to minutes and seconds cannot be queried in the normal way. The solution is as follows:

Accurate to date: select * from user where userId = 26 and createTime > # 2018 from user where userId 1 and createTime 2 accurate to minutes and seconds (wrong way): select * from user where userId = 26 and createTime = # "8:23:42 on 2018-1-25" # accurate to time minutes and seconds (the right way): select * from user where userId = 26 and createTime = cdate ("2018-1-25 8:23:42")

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.