Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent Query

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

 Copyright (c) 1982, 2005, Oracle. All rights reserved.

 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US