date format

[Anon]

Does any body knows how to change the default date format in oracle?
As i am trying to import data from sql server there my date format is mm/dd/yy but in oracle it is importing as dd-Mon-yyyy.

[Anon]

alter session
set NLS_DATE_FORMAT = 'MM/DD/YYYY';

OR

alter session
set NLS_DATE_FORMAT = 'MM/DD/YY HH24:MI:SS';

OR

whatever format you want