• 首先，Date是 Date_add() 函数.
• 我们可以使用 BETWEEN low-value AND high-value 比较运算符，以获取指定范围内的值.
• Firstly, Date is a Keyword in MySQL. You should really avoid using it as a table/column name.
• To get a time 1 hour before the current time, you can add an INTERVAL -1 HOUR to current time (NOW()), using Date_add() function.
• We can use BETWEEN low-value AND high-value comparison operator, to get the values from the prescribed range.

尝试以下查询:

SELECT * 
FROM sample.writing 
where Date BETWEEN DATE_ADD(NOW(), INTERVAL -1 HOUR) AND NOW()