Use a between to query a date range in Oracle
Posted on 2013-06-12
I am using the following query to select records that have a timestamp,(06/11/2013 08:15:22) thanks to experts on here who helped getting this to work.
select * from mytable
where mydate >= to_date( parameter ,'mm/dd/yyyy')
and mydate < to_date( parameter ,'mm/dd/yyyy') + 1
Now I need to somehow use a between in order to query records within a date range.
I have two parameters for mydate -- mybegindate and myenddate and I want all records between mybegindate and myenddate.
Thanks for your help.