Re: Urgent Query

From: sybrandb <sybrandb_at_gmail.com>
Date: 31 Jul 2006 05:26:35 -0700
Message-ID: <1154348795.270249.259070@h48g2000cwc.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

Are you by any change converting a date column to a date? Shouldn't it just be TO_CHAR(current_date.....

Just asking

As this is a volunteer forum, there is no such thing as 'urgent'. If it is urgent, call support.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Mon Jul 31 2006 - 07:26:35 CDT