Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NLS_DATE_FORMAT
>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