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 -> Urgent Query

Urgent Query

From: <deepagulati_at_rediffmail.com>
Date: 31 Jul 2006 04:59:11 -0700
Message-ID: <1154347151.285698.180610@i42g2000cwa.googlegroups.com>


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 Received on Mon Jul 31 2006 - 06:59:11 CDT

Original text of this message

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