See the alter session command at session level and NLS_DATE_FORMAT init paramter t database level