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 Oracle EBS Front-End Inaccessible After AD-TXK Delta 15 Upgrade Fixed by Updating Mod-security Rules Resolving the “Missing PATCH FS CONTEXT FILE” Error in FND_OAM_CONTEXT_FILES What New In ECCV9?