str4 = "select to_char(recording_date,'yyyy-mm-dd hh24:mi:ss') recording_date,to_char(time_point,'yyyy-mm-dd hh24:mi:ss')time_point,sale_value" _
& "from sale_value where time_point between" & DateAdd("h", -6, now) & now
查出之前六个小时的值,怎么将每半个小时的值求出来啊??
大家有没有什么好办法啊???
between" & (now - 6/24) & now