How to change Oracle Database NLS DATE FORMAT Home > People and Culture Blog > 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@doyensys.com Recent Posts The One Data Guard Step I Missed: Forgetting Standby Redo Logs (And How I Fixed It) How to Verify Transport, Apply Status, Gaps, and Errors in Oracle Data Guard Installing Oracle E-Business Suite Integrated SOA Gateway