这句SELECT语句该怎么写？？？

wzxiaodu 2004-08-23 11:12:16

"Select * from 表名 WHERE II='59' and " & Format(tT, "yyyyMMdd") & " =20040823 ORDER BY tT DESC"

运行这句时出现tTime”变量未定义“的错误，
tTime字段内容如”04-08-23 06:04:00 上午“。
请问该如何写啊？？？？？

...全文

170 点赞收藏 16

写回复

16 条回复

切换为时间正序

当前发帖距今超过3年，不再开放新的回复

发表回复

of123 2004-08-23

Select * from Table WHERE II='59' and tT = #2004-08-23# ORDER BY tT DESC

回复赞

Andy__Huang 2004-08-23

sql server 2000

sql="Select * from Table WHERE II='59' and convert(varchar,'" & tT & "',112) = '20040823' ORDER BY tT DESC“

回复赞

wzxiaodu 2004-08-23

vbman2003(家人) ：
由于这样
”Select * from Table WHERE II='59' and Format(tT, "yyyyMMdd") = '20040823' ORDER BY tT DESC“

出现了引号中的引号，也不行啊。我最初就是用这个的。

回复赞

wzxiaodu 2004-08-23

yimain(残雪) 一样

”‘format'不是可以识别的函数名“

回复赞

wzxiaodu 2004-08-23

qybao(阿宝)大哥：还是不行啊。还是出错。？？？

”‘format'不是可以识别的函数名“

回复赞

云路 2004-08-23

Select * from Table WHERE II='59' and Format(tT, 'yyyyMMdd') = '20040823' ORDER BY tT DESC

回复赞

vbman2003 2004-08-23

Select * from Table WHERE II='59' and Format(tT, "yyyyMMdd") = '20040823' ORDER BY tT DESC

回复赞

qybao 2004-08-23

Sql语句的问题
"Select * from 表名 WHERE II='59' and " & Format(tT, "yyyyMMdd") & " =20040823 ORDER BY tT DESC"
什么数据，初步判断是access
改成
"Select * from 表名 WHERE II='59' and Format(tT, " & chr(34) & "yyyyMMdd" & chr(34) & ") = '20040823' ORDER BY tT DESC"
试试

回复赞

starsoulxp 2004-08-23

先查询tT字段

sql="select tT from 表名"
rs.open sql,conn

然后再
sql="Select * from 表名 WHERE II='59' and " & Format(re!tT, "yyyyMMdd") & " =20040823 ORDER BY tT DESC"

回复赞

starsoulxp 2004-08-23

你应该把tT字段的内容取出来，然后Format(rs!tT,"yyyyMMdd")

回复赞

wzxiaodu 2004-08-23

"Select * from 表名 WHERE II='59' and " & Format(tT, "yyyyMMdd") & " =20040823 ORDER BY tT DESC"

运行这句时出现 tT ”变量未定义“的错误，
tT 字段内容如”04-08-23 06:04:00 上午“。
请问该如何写啊？？？？？

回复赞