Question

asp如何读取access数据库里的日期呢？

用SUB过程写的数据库连接，如下：
sub GetXwzx()
sql="select top 7 id,title,Sdate from TbNews where sort in(13,14,15) order by [order] desc"
rs.open sql,conn,1,1
if not rs.eof then
do while not rs.eof
response.write("<div style='clear:both;'>")
response.write("<div style='width:190px;float:left;height:26px;line-height:26px;'>")
response.Write("· <a href='News_Show.asp?NewsID="&rs("id")&"' target='_blank' class='C_010101' ")
if CheckStringLength(rs("title"))>26 then
response.Write(" title='"&rs("title")&"' >"&InterceptString(rs("title"),23)&"...")
else
response.Write(" >"&rs("title"))
end if
response.Write("</a>")
response.Write("</div>")
response.write("<div style='height:26px;line-height:26px;'>")
response.Write(right(year(Sdate),2)&"-"&right("0"&month(Sdate),2)&"-"&right("0"&day(Sdate),2))
response.write("</div>")
response.Write("</div>")
rs.movenext
loop
end if
rs.close
end sub
结果时间显示的都是99-12-30
怎样才能显示数据库里的正确时间呢，数据库里的时间是2013-10-12

Answer 1

response.Write year(rs("Sdate"))&"-"&Month(rs("Sdate"))&"-"&day(rs("Sdate"))

Answer 2

response.Write(right(year(Sdate),2)&"-"&right("0"&month(Sdate),2)&"-"&right("0"&day(Sdate),2))
直接输出时间字段

Answer 3

response.Write(right(year(cdate(Sdate)),2)&"-"&right("0"&month(cdate(Sdate)),2)&"-"&right("0"&day(cdate(Sdate)),2))