Hi, everybody,

I have a question about to_date:

SQL> select to_char( to_date(5373484,'J'),'Jsp') from dual;

TO_CHAR(TO_DATE(5373484,'J'),'JSP')
--------------------------------------------------------------------------
Five Million Three Hundred Seventy-Three Thousand Four Hundred Eighty-Four

BUT:
SQL> SELECT TO_CHAR(TO_DATE(5373484,'J'), 'DD-MON-YYYY') sth FROM dual;

STH
-----------
31-DEC-9999

My quesition is to_date(integer, 'J') stands for what? This integer must be between 1 to 5373484.

I got this:
SQL> SELECT TO_CHAR(TO_DATE(1,'J'), 'DD-MON-YYYY') sth FROM dual;

STH
-----------
01-JAN-4712

Could anyone please explain it? Where is 4712 from?
Many thanks.