Re: Urgent Query

From: HansF <Fuzzy.Greybeard_at_gmail.com>
Date: Mon, 31 Jul 2006 13:24:59 GMT
Message-Id: <pan.2006.07.31.13.27.20.875074@gmail.com>

On Mon, 31 Jul 2006 04:59:11 -0700, deepagulati 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

It's worse than that. Here is an actual run:

pop2_at_fuzzy:~> sqlplus hr/hr

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jul 31 07:21:25 2006

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

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

TO_DATE(CURRENT_DA

31-JUL-06 SQL> You may want to provide some additional info about your system. For example, tell us the NLS settings and show the output from a simple select of current_date (and/or sysdate) without using a conversion function. (And version and operating system are always interesting, as these help eliminiate nagging sideline questions.)

Truly curious why you consider this 'urgent'.

-- 
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)   
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.

Received on Mon Jul 31 2006 - 08:24:59 CDT