Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help with date format !!!! urgent
I resolved temporary the problem using trigger
create or replace trigger logon_trigger
after logon on database
declare
xOsUser varchar2 (30);
xSid number;
begin
execute immediate 'Alter session Set NLS_DATE_FORMAT = "YYYY-MM-
DD"';
end;
/
Received on Tue Jun 12 2007 - 04:06:46 CDT