Hi

I thin nls_date_format going to change the format as per ur request in the server but its going to effect over all who ever acess the that server .

We can always change the format ,bascially when user wants to store in different date formats he needs to use to_date and to_char for formatiing .

I dont think we need to change nls_date_format

Thanks
lnreddy