Re: Urgent Query

From: <fitzjarrell_at_cox.net>
Date: 31 Jul 2006 06:39:05 -0700
Message-ID: <1154353145.012777.141010@75g2000cwc.googlegroups.com>

deepagulati_at_rediffmail.com wrote:
> Hi,
> This query
> select to_date(CURRENT_DATE,'dd/mm/yyyy hh:mi:ss AM') from dual;
>
> returnig the result as 31/07/0006 while the current year is 2006 ???
>
> plz help

Oracle version would help tremendously. And, gee whiz, this works on 10.2.0.2:

SQL> alter session set nls_date_format = 'DD/MM/RRRR HH:MI:SS AM';

Session altered.

SQL> select to_date(CURRENT_DATE,'dd/mm/rrrr hh:mi:ss AM') from dual;

TO_DATE(CURRENT_DATE,'

---

31/07/2006 08:36:39 AM

SQL> I agree with Sybrand; if this is TRULY urgent contact Oracle support.

David Fitzjarrell Received on Mon Jul 31 2006 - 08:39:05 CDT