SELECT NOW(), CURDATE(), CURTIME()
    image.png
    SELECT YEAR(NOW())
    SELECT MONTH(NOW())
    SELECT DAY(NOW())
    EXTRACT是标准SQL语言的一部分
    image.png
    image.png
    SELECT *
    FROM orders
    WHERE YEAR(order_date) = YEAR(NOW())