我在进行SQL表查询的时候.
输入如下语句:
SELECT *
FROM SEND
WHERE SEND_TIME LIKE '%2007-6-8%'
结果显示:
"当前"SQL"窗格内容做语法分析时发生下列错误:
输入项无法被转换为有效日期时间值."请各位路过的高手帮个忙!小弟在线等!
输入如下语句:
SELECT *
FROM SEND
WHERE SEND_TIME LIKE '%2007-6-8%'
结果显示:
"当前"SQL"窗格内容做语法分析时发生下列错误:
输入项无法被转换为有效日期时间值."请各位路过的高手帮个忙!小弟在线等!
-----------------------------------
不对
FROM SEND
WHERE convert(varchar(10),SEND_TIME,120) LIKE '%2007-06-08%'
FROM SEND
WHERE convert(varchar(10),SEND_TIME,120) = '2007-06-08'
FROM SEND
WHERE CONVERT(varchar(30),SEND_TIM,102) LIKE '%2007-6-8%'
不过没心要这样 SELECT *
FROM SEND
WHERE CONVERT(varchar(30),SEND_TIM,102) ='2007-06-8'
FROM SEND
WHERE SEND_TIME LIKE '%2007-6-8%'
--------------------------------------
改成:
SELECT *
FROM SEND
WHERE convert(varchar(10),SEND_TIME,101) LIKE '%2007-6-8%'
FROM SEND
WHERE SEND_TIME LIKE '%2007-6-8%'
--------------------------------------
改成:
SELECT *
FROM SEND
WHERE convert(varchar(10),SEND_TIME,101) LIKE '%2007-6-8%'
FROM SEND
WHERE SEND_TIME LIKE '%2007-6-8%'
--------------------------------------
改成:
SELECT *
FROM SEND
WHERE convert(varchar(10),SEND_TIME,101) LIKE '%2007-6-8%'
FROM SEND
WHERE convert(char(10),SEND_TIME,120) = convert(char(10),'2007-6-8',120)
FROM SEND
WHERE Convert(nvarchar(50),Convert(datetime,SEND_TIME),23) LIKE '2007-06-08'
SELECT * FROM SEND WHERE datediff(dd,SEND_TIME,'2007-06-08')=0
朋友们写的那些代码是可以运行的.
不过,我在ASP里加进去后,就不再有效!
我的部分代码是:
<%
dim times
times=request.Form("year")&"-"&request.Form("month")&"-"&request.Form("date")
if request.Form("action")="send_yxtime" then
sql="select * from send where send_yxtime like '%"×&"%'"
elseif request.Form("action")="send_time" then
sql="select * from send where send_time like '%"×&"%'"
else
sql="select top 1000 * from send order by send_time DESC"
end if
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,3 %>
<tr>
<td><%
if rs.eof and rs.bof then
response.write "暂未加入栏目" %>
</td>
</tr>
还想请大家帮我看看!!!
smalldatetime
一个网站的开发时间是很短的,如果在一个Time上浪费太多的时间实在是不划算
SELECT *
FROM SEND
WHERE SEND_TIME = '2007-6-8'
应该可以了
sql="select * from send where Convert(nvarchar,send_yxtime,23) = Convert(nvarchar,Convert(datetime,'"×&"'),23)"
elseif request.Form("action")="send_time" then
sql="select * from send where Convert(nvarchar,send_time,23)= Convert(nvarchar,Convert(datetime,'"×&"'),23)"
FROM SEND
WHERE SEND_TIME = '2007-Jun-08'或者 直接这样就行
SELECT *
FROM SEND
WHERE SEND_TIME like '%2007-Jun-08'