怎么用QUERY写日期查询(查询出某年奇数日的数据)？ (50分)

X

xmdsj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-17

• #1

我用的是interbase数据库.其中一个表中有一个日期时间型字段.
请问如何用QUERY查询出某年奇数日的数据？

如:2000-01-01 2000-01-13 2000-03-15 2000-08-17 等

 

Q

QuickSilver

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-17

• #2

ACCESS中
SELECT * FROM table1 WHERE year(rq)=2002 and (day(rq) mod 2)=1

MSSQL中
SELECT * from table1 where year(rq)=2002 and day(rq)%2=1

interbase请相应更改取余操作符和日期函数

 

X

xmdsj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-18

• #3

to:QuickSilver

在interbase 中没有year函数.

 

Q

QuickSilver

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-18

• #4

select * from "c:/temp/table1.db"
where EXTRACT(YEAR FROM rq)=2002 and
EXTRACT(day FROM rq) in (1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31)

或你试试这句，自己要相应修改以适应interbase

 

X

xmdsj

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-08-18

• #5

谢谢