oracle 取某个时间段的数据,具体代码如下所示:
select count(*),t.分组字段 from (
select t.* ,to_char(t.时间,'hh24') stime,to_char(t.时间,'hh24mi') fz,to_char(时间,'d')
from a t
where 时间>=to_d...
直接上代码
测试类
public class testdata {
public static void main(string[] args) {
list<tsdata> list = new arraylist<>();
list.add(new tsdata("11","08",11111l));
list.a...
自己写的一方法
/**
* judge the current time is on the time, for example: current is 11:00, startTimeStringFormat=10:00,endTimeStringFormat==12:00,you will get true
*
...