Oracle convert date to number:

to convert date to number you have to write this select

TO_NUMBER(TO_CHAR(d))

With this Oracle conversion the date is converted from data type char to a number.

Yasser