Oracle笔记
1,Oracle中插入时间:
1
insert into tuserexpendtab
2
values
3
(
4
'00003','jcleung',sysdate,sysdate,
5
to_date('2009-01-20 01:00:23', 'yyyy-MM-dd hh24:mi:ss'),
6
'0005','-','-',
7
'baoyue',50,'haha'
8
);
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2,查询指定时间范围内的记录:
1
SELECT *
2
FROM A
3
WHERE ENDTIME>sysdate AND ENDTIME<(sysdate+numtodsinterval(?,'SECOND'))
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)