各位高手，我的时间控件默认为系统时间，如何改为yyyy-mm-dd格式？？？

[nightwind2002]

<OBJECT
classid=clsid:20DD1B9E-87C4-11D1-8BE3-0000F8754DA1 height=22
id=text6 name=text6 width=98>
<param name="_ExtentX" value="2593">
<param name="_ExtentY" value="582">
<param name="_Version" value="393216">
<param name="MousePointer" value="0">
<param name="Enabled" value="1">
<param name="OLEDropMode" value="0">
<param name="CalendarBackColor" value="-2147483643">
<param name="CalendarForeColor" value="-2147483630">
<param name="CalendarTitleBackColor" value="-2147483633">
<param name="CalendarTitleForeColor" value="-2147483630">
<param name="CalendarTrailingForeColor" value="-2147483631">
<param name="CheckBox" value="0">
<param name="CustomFormat" value>
<param name="DateIsNull" value="0">
<param name="Format" value="662831105">
<param name="UpDown" value="0">

<param name="MaxDate" value="2958465">
<param name="MinDate" value="-109205"></OBJECT>


我用SQL语句添加数据时，显示to_date('2003-4-10 15:08:04','yyyy-mm-dd')
我该怎么让取出的日期为2003-4-10 ，而不是2003-4-10 15:08:04 ？？？？？
这样我才能向数据库中添加记录呀！！！

[sinzy]

FormatDateTime(你取出的时间字符串, vbShortDate)

[hubinasm]

formatdatetime(str,2)

[quiet]

formatdatetime(yourdatetime,2)

[jobine]

response.Write Formatdatetime("2003-4-10 15:16:40",vbShortDate)

[nightwind2002]

asp脚本为什么不认FormatDateTime(你取出的时间字符串, vbShortDate)

显示入下“
错误类型：
Microsoft VBScript 编译器错误 (0x800A0414)
/scheduling/asp/check_storage_manhour.asp, 第 204 行, 第 34 列
FormatDateTime(text6, vbShortDate)
---------------------------------^

[61]

iniSTime=datediff("d",cdate("1899-12-30"),cdate(date()))
<object classid="clsid:20DD1B9E-87C4-11D1-8BE3-0000F8754DA1" codeBase="../activex/mscomct2.cab" id="dtpStartTime" name="dtpStartTime" >
<param NAME="_ExtentX" VALUE="4498">
<param NAME="_ExtentY" VALUE="582">
<param NAME="_Version" VALUE="393216">
<param NAME="MousePointer" VALUE="0">
<param NAME="Enabled" VALUE="0">
<param NAME="OLEDropMode" VALUE="0">
<param NAME="CalendarBackColor" VALUE="-2147483643">
<param NAME="CalendarForeColor" VALUE="-2147483630">
<param NAME="CalendarTitleBackColor" VALUE="-2147483633">
<param NAME="CalendarTitleForeColor" VALUE="-2147483630">
<param NAME="CalendarTrailingForeColor" VALUE="-2147483631">
<param NAME="CheckBox" VALUE="0">
<param NAME="CustomFormat" VALUE>
<param NAME="DateIsNull" VALUE="0">
<param NAME="Format" VALUE="662831104">
<param NAME="UpDown" VALUE="0">
<param NAME="CurrentDate" VALUE="<%=iniSTime%>">
<param NAME="MaxDate" VALUE="2958465">
<param NAME="MinDate" VALUE="-109205">
<object>

[dh20156]

datevalue(now)