How to set NLS DATE LANGUAGE in SQL query?

 To set NLS DATE LANGUAGE in SQL query use the below:


SELECT  To_char(sysdate, 

'DD-MON-YYYY HH24:MI:SS', 
'NLS_DATE_LANGUAGE=AMERICAN'
)
FROM   dual; 


Comments