数据库中的时间格式如下:“2015-4-14 16:01:33”
要查询所有“2015-4-14 16:01”的记录dim i_year, i_month, i_day, i_hour, i_minute, i_fznum As Integer
'定义年/月/日/时/分/分站号
choosesql = "select * from fenzhan"
choosesql = choosesql & i_fznum '分站号
choosesql = choosesql & " where SystemTime like '"
choosesql = choosesql & i_year & "-"
choosesql = choosesql & i_month & "-"
choosesql = choosesql & i_day & " "
choosesql = choosesql & i_hour & ":"
choosesql = choosesql & i_minute & "*'"这句话应该怎么写?
要查询所有“2015-4-14 16:01”的记录dim i_year, i_month, i_day, i_hour, i_minute, i_fznum As Integer
'定义年/月/日/时/分/分站号
choosesql = "select * from fenzhan"
choosesql = choosesql & i_fznum '分站号
choosesql = choosesql & " where SystemTime like '"
choosesql = choosesql & i_year & "-"
choosesql = choosesql & i_month & "-"
choosesql = choosesql & i_day & " "
choosesql = choosesql & i_hour & ":"
choosesql = choosesql & i_minute & "*'"这句话应该怎么写?
哦,抱歉,我的意思是:
SystemTime(本条记录加入时间)是表中的一个字段,格式如:“2015-4-14 16:01:33”
判断取出所有年,月,日,小时,分吻合的记录,秒不考虑,比如取出所有2015-4-14 16:01的记录,从2015-4-14 16:01:01到2015-4-14 16:01:59都算.
这次说明白了吗?谢谢
choosesql = choosesql & " where Convert(Nvarchar(20),SystemTime,120) Like '"
choosesql = choosesql & i_year & "-"
choosesql = choosesql & i_month & "-"
choosesql = choosesql & i_day & " "
choosesql = choosesql & i_hour & ":"
choosesql = choosesql & i_minute & "%'"
先谢谢。fenzhan & i_fznum 是表名,
不过where Convert(Nvarchar(20),SystemTime,120) Like 中
Convert()是什么意思?函数?
请指教.