Convert a date in a number

[claude69]

Hi guys, I need to convert a series of Date in a sequence of number, there is someone that have a script precompiled.
Thanks

 

[Saluk]

Use Julian dates, see function TO_CHAR in SQL Reference documentation.

Example:
SELECT TO_NUMBER(TO_CHAR (hire_date, 'J')) FROM employees;