laoxie_198 发表于 2007-5-14 15:26:00

时间函数问题

<p>mytime = CDate(Date)在vba里的值是:2007-05-14 15:0000<br/>可我用cn.Execute "insert into tysx values (" &amp; tyidh &amp; ", '" &amp; tysx &amp; "', " &amp; mytime &amp; "," &amp; dwsm + 1 &amp; ",'" &amp; obj.layer &amp; "',1,'" &amp; obj.Linetype &amp; "')"将他写到库里的时候怎么变成1905-05-28 00:00:00了?</p><p>请高手指点!!</p>
页: [1]
查看完整版本: 时间函数问题