一个关于sql 时间比较的问题

[huiu007]

select * from article where chackd=True and catsonid=1 and p_date >2005-1-12 and p_type='出售' order by p_id desc


我想搜索一下时间大于2005-1-12 地，这样写对吗。

可是出来的结果把小于2005-1-12的也列出来了，
大虾们帮忙啊，谢谢离

[游陆]

sql中用以下语句

<%
set rs=server.createobject("adodb.recordset")
xztime=now()
rs.open "select * from learning where '" & xztime & "' >= starttime and '" & xztime & "' <= stoptime",conn,1,1
%>

Access中用以下：
<%
set rs=server.createobject("adodb.recordset")
xztime=now()
rs.open "select * from learning where #" & xztime & "# >= starttime and #" & xztime & "# <= stoptime",conn,1,1
%>

[szjhxu]

如果用的是ACCESS数据库,则:
select * from article where chackd=True and catsonid=1 and p_date >#2005-1-12# and p_type='出售' order by p_id desc