用ASP方式,将一个字段的文本型改成日期型,然后把数据全部写到另一个数据表中,

[8874357950]

文本型字段的内容是"20030504"
改成"2003-05-04 00:00:00"

[zhanghao5188]

strdate = "20030504"
strdate = Left(strdate, 4) & "-" & Mid(strdate, 5, 2) & "-" & Right(strdate, 2)
Strs = (strdate & " " & "00:00:00")
crdate=Cdate(strs)

[fangpeng2003]

<%
date1="20030506"

date2=left(date1,4)&"-"&right(left(date1,6),2)&"-"&right(date1,2)&" 00:00:00"

response.write date2
%>

[lxqlogo0]

strdate = "20030504"
strdate = Left(strdate, 4) & "-" & Mid(strdate, 5, 2) & "-" & Right(strdate, 2)
Strs = (strdate & " " & "00:00:00")

[angelheavens]

dd="20030504"
if len(dd)<>8 then
response.write "日期有误"
response.end
end if

y1=mid(dd,1,4)
m1=mid(dd,5,2)
d1=mid(dd,7,2)

curdate=Cdate(y1&"-"&m1&"-"&d1)

sql="insert into(name,update) values('"&name&"','"&curdate&"')"
conn.execute(sql)