Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "mysql date comparison sentence". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Select * from student where '2012-02-27 00 purl 0000'

Created_date

Select * from student where UNIX_TIMESTAMP ('2012-02-27 00 00')

UNIX_TIMESTAMP (created_date)

SELECT * FROM student WHERE (UNIX_TIMESTAMP (created_date)-UNIX_TIMESTAMP ('2012-02-26 00 created_date 0000)) > = 0 AND (UNIX_TIMESTAMP (created_date)-UNIX_TIMESTAMP (' 2012-02-29 00 UNIX_TIMESTAMP 0000))

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.