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

Re: NLS_DATE_FORMAT

From: wegorz <wegorz_at_winuel.com.pl>
Date: Thu, 16 Nov 2000 10:14:27 +0100
Message-ID: <8v08ed$li7$1@news.tpi.pl>

>the format is
>dd-MON-yy
>but i need the format 'dd/mm/yyyy hh24:mi:ss'

Do not do this on the database server. You must set NLS_LANG on the client! In the registry on Windows, in the environment on Unix (.profile).

Andrew Rajczakowski Received on Thu Nov 16 2000 - 03:14:27 CST

Original text of this message

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