Convert date stored in Character to Date Format.

If you store date in Character format and we need to perform a selection on date between.

Use the following query as an example.

select * from pdsn_cdrs where
trunc(to_date(to_char(charge_start_date),'MM/DD/YYYY HH24:MI:SS')) between '01-July-2009' and '31-July-2009'