Re: SQL - Time Specific Daily Query

CRS_UK wrote:

> The (2AM and 3AM) is the part that I am having trouble with. If it
> were one specific, I would use TO_DATE('2006-12-06
> 02:00:00','YYYY-MM-DD HH24:MI:SS'). But since it is everyday, I'm
> stuck.

to_char(date,'HH') will extract the hour value from a given date.

(unforturately, the extract function cannot be used against a date).

HTH. Kind regards,

-- 
spamto:cris119_at_operamail.com

blind faith in your leaders or
in anything will get you killed