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 -> NLS_DATE_FORMAT

NLS_DATE_FORMAT

From: <subrar_at_my-deja.com>
Date: Thu, 16 Nov 2000 02:57:40 GMT
Message-ID: <8uvif1$cv9$1@nnrp1.deja.com> 






Hi,


I need to change the date format to 'dd/mm/yyyy hh24:mi:ss'
I changed in init.ora parameters


shutdown and startup the oracle instance .
but it if i select sysdate from dual


the format is


dd-MON-yy


but i need the format 'dd/mm/yyyy hh24:mi:ss'



please help in this issue




Sent via Deja.com http://www.deja.com/


Before you buy.
Received on Wed Nov 15 2000 - 20:57:40 CST












Original text of this message













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