Question

sql如何查询某段时间内的数据 时间格式 yyyy-mm-dd vb.net 两个DateTimePicker 选择 某段时间

Dim strSQL As String = "select 门诊划价明细.药品编号,药品资料.名称,门诊划价明细.单价,门诊划价明细.数量,药品资料.入库单价,药品资料.出库单价,门诊划价明细.金额,门诊划价.收费时间 from 门诊划价明细, 药品资料,门诊划价 where 门诊划价明细.药品编号=药品资料.编号 and 门诊划价明细.划价编号=门诊划价.编号 and 门诊划价.划价时间 >= " & DateTimePicker1.Text.Trim & " and 门诊划价.划价时间 <= " & DateTimePicker2.Text.Trim & " "

Answer 1

可以用between and

追问

怎么写 可以把 门诊划价.划价时间 >= " & DateTimePicker1.Text.Trim & " and 门诊划价.划价时间 <= " & DateTimePicker2.Text.Trim & " " 这个 用你说的写出来吗

追答

可以啊，门诊划价.划价时间 between " & DateTimePicker1.Text.Trim & " and " & DateTimePicker2.Text.Trim & " 大体上类似这样

追问

可是这样写 报错啊 我的划价时间是datatime类型的

追答

要不就转换一下，between convert(datetime," & DateTimePicker1.Text.Trim & ") and convert(datetime," & DateTimePicker2.Text.Trim & ")