Hmm, not really sure what you're getting at...

A date is a date is a date. How it is displayed is irrelevent. You can display it in any format you want:

Code:
SQL> select to_char(d,'mm/dd/yyyy') from xyz;

TO_CHAR(D,
----------
09/30/2002
10/30/2002
10/15/2002

SQL> select to_char(d,'mon-yyyy-d') from xyz;

TO_CHAR(D,
----------
sep-2002-2
oct-2002-4
oct-2002-3

SQL> select to_char(d,'mi:ss:hh month-yyyy-ddd') from xyz;

TO_CHAR(D,'MI:SS:HHMONTH-YY
---------------------------
29:06:01 september-2002-273
29:17:01 october  -2002-303
29:27:01 october  -2002-288