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 -> Change Data format in a Scheme

Change Data format in a Scheme

From: Flex <flexNOSP_at_Mfreemail.it>
Date: Tue, 02 Apr 2002 11:22:01 GMT
Message-ID: <tvgq8.51076$S52.1744419@news2.tin.it>


I have a Scheme in Oracle 8i , and I want to change date format. Now when , for example ,I do : Select SYSDATE from DUAL ; I obtain 02-apr-2002 , I'd like that system return 02-04-2002. How can I obtain this ?

Hello
Flex

P.S. Excuse me 4 my bad English !!! Received on Tue Apr 02 2002 - 05:22:01 CST

Original text of this message

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