find data between specific times within a range of dates
798490Sep 17 2010 — edited Sep 17 2010hii all,
i am reasonably new to PL/SQL so any help will be greatly appreciated. i am trying to retrieve data from a set of tables. one of these tables has a field which is a timestamp field in 'dd/mm/yyyy hh24:mi:ss' format. i have been asked to produce data for records that were created between 16:00 and 20:00 between 01/01/2010 and the 31/08/2010. I can mange the date issue but the time issue is the one i am stuck on.
your help would be appreciated