I have an Oracle date problem I want to use in the where also a time filter not just a date filter, how do I add it?
select count(*)
from table
where DTTM > '10-Jun-08';
Thank you.
All dates are actually date-time fields - if you don't specify the time, Oracle defaults to midnight. To filter date-time specify the date-time string as a formatted field like this:
select count(*) from mytable where dttm > to_date('20080610181907','YYYYMMDDHH24MISS');
This is the date June 10, 2008 at 6:19:07 PM as an example.
779 views
Usually answered in minutes!
×