How to change Oracle Database NLS DATE FORMAT

Here is the below statement.

alter system set nls_date_format=’dd.mm.yyyy hh24:mi:ss’ scope=spfile

Marimuthu Pandu

• marimuthu.pandu@staging.doyensys.com