列出某一天, 上一星期的数据
Select
distinct
dateandtime
FROM
ctdate_by_query_date
Where
dateandtime
between
((#
2006
-
5
-
15
#
+
(Weekday(
2006
-
5
-
15
)
-
7
))
-
6
)
and
(#
2006
-
5
-
15
#
-
7
)
+
Weekday(
2006
-
5
-
15
)
sql = " Select distinct dateandtime FROM ctarticle Where dateandtime between ((#" & date & "# + (Weekday(" & date & ")" & norp & " 7 )) - 6 ) and (#" & date & "#" & norp & " 7 ) + Weekday(" & date & ")"
sql = " Select distinct dateandtime FROM ctarticle Where dateandtime between ((#" & date & "# + (Weekday(" & date & ")" & norp & " 7 )) - 6 ) and (#" & date & "#" & norp & " 7 ) + Weekday(" & date & ")"
查询一天, 所隶属星期所有天数的数据
Select
*
FROM
ctdate_by_query_date
Where dateandtime between ((# 2006 - 5 - 15 # + Weekday( 2006 - 5 - 15 )) - 6 ) and # 2006 - 5 - 15 # + Weekday( 2006 - 5 - 15 )
Where dateandtime between ((# 2006 - 5 - 15 # + Weekday( 2006 - 5 - 15 )) - 6 ) and # 2006 - 5 - 15 # + Weekday( 2006 - 5 - 15 )
程序代码
Select
*
FROM
ctdate_by_query_date
Where
dateandtime
between
#
2006
-
5
-
1
#
and
#
2006
-
5
-
30
#
列出不同年份的年份, 并且不要相同
select
distinct
year
(dateandtime)
from
ctarticle
果如:
Expr1000
2000
2003
2004
2005
2006
列出某一天, 上一年的第一条记录
Select
top
1
dateandtime
FROM
ctarticle
where
year
(dateandtime)
=
(
2006
)
-
1
sql = " Select top 1 dateandtime FROM ctarticle where year (dateandtime) = ( year (#" & date & "#))" & norp
sql = " Select top 1 dateandtime FROM ctarticle where year (dateandtime) = ( year (#" & date & "#))" & norp
列出某一年的数据
sql
=
"
select
*
from
ctdate_by_query_date
where
year
(dateandtime)
=
"
&
year
(rqqdt_)
&
"
order
by
dateandtime
desc
"
查找上一月中的第一条记录
Select
top
1
dateandtime
FROM
ctarticle
where
year
(dateandtime)
=
year
(#
2006
-
5
-
28
#)
and
month
(dateandtime)
=
month
(#
2006
-
5
-
28
#)
-
1
列出某一月的数据
sql
=
"
select
*
from
ctdate_by_query_date
where
year
(dateandtime)
=
"
&
year
(rqqdt_)
&
"
and
month
(dateandtime)
=
"
&
month
(rqqdt_)
&
"
order
by
dateandtime
desc
"
列出某一日的数据
sql
=
"
select
*
from
ctdate_by_query_date
where
dateandtime
=
#"
&
rqqdt_
&
"#
order
by
a.articleid
desc
"
时间日期
例一: 列出当天的数据
sql
=
"
select
*
from
ctdate_by_query_date
where
dateandtime
=
date()
order
by
a.articleid
desc
"