Hi,

How do you change the NLS_DATE_FORMAT in Initialization parameter file. I know that I can do it in my session either Alter session or Have it in Login File.

But How do you do that in Init.Ora file, it always gives me error I have tried putting in Single quotes and Double quotes but no Help.

This is what I want about the date format ... Oracle 8.1.6/Win2000

Day Month DDth YYYY HH:MI:SS AM

This is the format that I want for my database... Please assist. Thanks