| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Quering a specific TIME not date
> Where to_date(fieldname,'24H:MI') >=to_date('10:00',24H:MI')
you could try
where to_number(to_char(fieldname,'HH24')) >= 10
OR
where to_number(to_char(fieldname,'HH24')) BETWEEN 10 AND 13
OR
10:15:00 AND 13:30:00
where to_number(to_char(fieldname,'HH24MISS')) BETWEEN 101500 AND
133000
Received on Fri Jan 26 2007 - 07:25:13 CST
 |
 |