怎样 取出时间日期型的日期 例如取出"2003-12-13 9:00:00" 的"2003-12-13

[chuying]

我想 问一下有没有这样的函数 一下就可以取出
还有我想 在选择记录时 where 语句可以这样写吗?
select * from aa where item_code=101 and(sampling_time>'2003-11-29' and sampling_time<'2003-12-2')

[northwolves]

Private Sub Command1_Click()
Dim d As Date
d = #12/13/2003 9:00:00 AM#
MsgBox Format(d, "yyyy-mm-dd")
End Sub

[rainstormmaster]

Private Sub Command1_Click()
Dim a As Date
a = Now
Debug.Print a
Dim b As Date
b = DateValue(a)
Debug.Print b
End Sub

[SoHo_Andy]

1、msgbox format("2003-12-13 9:00:00","yyyy-mm-dd")
2、可以这样
select * from aa where item_code=101 and ( sampling_time between '2003-11-29' and '2003-12-2')