MS Access SQL 选择日期范围 [英] MS Access SQL to Select date range

查看：125 发布时间：2021/6/4 18:47:19 sql ms-access

本文介绍了MS Access SQL 选择日期范围的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

我需要选择带有日期的记录(范围:1998 年到 1999 年).我写的声明似乎确实有效.为什么?

I need to select a record with dates which has dates ( in range: form 1998 to 1999). I wrote the statement which did seem to work . Why?

SELECT *
FROM Factory
WHERE 
(EXTRACT(YEAR FROM date) AS dyear) BETWEEN '1998'  AND '1999'

您可以使用 YEAR() 从日期开始获取年份.

You can use YEAR() to get the year from the date.

SELECT *
FROM   Factory
WHERE  YEAR(date) BETWEEN 1998 AND 1999

这篇关于MS Access SQL 选择日期范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文