Question

asp控制数据是每天的

LoginTimes=rs0("LoginTimes")

怎么把这个数据控制在每天内的
就是读取24小时内的....
只提取当天的数据

Answer 1

你在查询的时候就只查询当天的数据就行了
select * from [table] where datediff(d,LoginTimes,now())=0
这样查询出来就只有当天的数据
如果是SQL SERVER数据库就把now()换成getdate()

Answer 2

????,不明白楼主意思!!!
LoginTimes=rs0("LoginTimes")
if datediff("d",LoginTimes,now())<>0 then
LoginTimes = ""
end if

Answer 3

select * from 表 where loginTimes between #" & FormatDT(Now(),5) & "# and #" & FormatDT(Now()+1,5) & "#"

'附上FormatDT函数
'格式化时间日期
Public Function FormatDT(dt, style)
'style=0 2000-10-10 下午 12:17:45
'style=1 2000-10-10 23:17:45
'style=2 2000-10-10 23:45
'style=3 00-10-10 23:45
'style=4 10-10 23:45
'style=5 2000-10-10
'style=6 00-10-10
'style=7 10-10
'style=8 23H-45M-45S
'style=9 20001010231745
'style=10 0510 上传图片
'style=11 05 年 10 月 10 日
'style=12 05/10/12 上传图片

Dim nowdate, y, m, d, h, i, s, t, APM, hAPM
nowdate = dt
y = Year(nowdate)
if len(y)=1 then y="0"&y
m = Month(nowdate)
if len(m)=1 then m="0"&m
d = Day(nowdate)
if len(d)=1 then d="0"&d
h = Hour(nowdate)
if len(h)=1 then h="0"&h
i = Minute(nowdate)
if len(i)=1 then i="0"&i
s = Second(nowdate)
if len(s)=1 then s="0"&s
If h > 12 Then
APM = "下午 "
hAPM = CStr(CInt(h) Mod 12)
Else
APM = "上午 "
hAPM = h
End If
Select Case style
Case 0
t = y & "-" & m & "-" & d & " " & APM & hAPM & ":" & i & ":" & s
Case 1
t = y & "-" & m & "-" & d & " " & h & ":" & i & ":" & s
Case 2
t = y & "-" & m & "-" & d & " " & h & ":" & i
Case 3
t = Right(y, 2) & "-" & m & "-" & d & " " & h & ":" & i
Case 4
t = m & "-" & d & " " & h & ":" & i
Case 5
t = y & "-" & m & "-" & d
Case 6
t = Right(y, 2) & "-" & m & "-" & d
Case 7
t = m & "-" & d
Case 8
t = h & "H-" & i & "M-" & s &"S"
Case 9
t = y & m & d & h & i & s
Case 10'上传
t = Right(y, 2) & m
Case 11
t = Right(y, 2) & " 年 " & m & " 月 " & d & " 日 "
Case 12
t = Right(y, 2) & "/" & m & "/" & d
End Select

FormatDT = t
End Function