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'

Learn some Japanese also

"Otaku desu"
means "I'm a nerd"
in Japanese.

Excerpts from Interview with Lary Wall (PERL Guru).

Oracle substr() equivalent function in Excel

For converting 911120202020 into 20202020

please use the excel function

=MID(A1,SEARCH("9111",A1)+4,8)