alter session parameter : nls_date_format

Friday, January 25 2007

select to_char( sysdate, 'Day, Month DD YYYY' ) from dual;

alter session set NLS_TERRITORY = 'AMERICA';
alter session set nls_date_format = 'Day, Month DD YYYY';
select sysdate from dual;