Re: Query Date by Time

Well,
- doing a trunc (sysdate - 1) will get you yesterday

• to_char (sysdate,'HH24') can get you the hour component (23)
• to_char (my_date_col,'MI') between '00' and '30' can be used as a predicate to filter rows

By combining the functions together, you could end up with something like...
my_date_col between to_date(to_char(sysdate-1,'YYYYMMDD')||' 23:00:00'),'YY...

hth Received on Mon Nov 06 2006 - 12:42:27 CST