Re: Date Question

From: Anurag Varma <avoracle_at_gmail.com>
Date: 21 Mar 2006 12:59:23 -0800
Message-ID: <1142974763.466005.127060@i40g2000cwc.googlegroups.com>

I don't think he is referring to the year zero problem. He seems to be getting the following date when using sqlplus:  00-00-0000 00 00:00:00

while he gets the right date back when using pl/sql.

I for one am not able to reproduce this issue in 9.2.0.6.

ORA92> select to_char((trunc(sysdate)-732757),'DD-MM-YYYY AD HH24:MI:SS')
from dual; 2

TO_CHAR((TRUNC(SYSDATE)-732757

---

02-01-0000 AD 00:00:00

Maybe its a bug .. and requires a patch.

Anurag Received on Tue Mar 21 2006 - 14:59:23 CST