I am using the code below to set tyhe NLS_DATE_FORMAT
Set AltSess = Server.CreateObject("ADODB.Connection")
AltSess.Execute "ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YY'"
This change appears to be being overridden. I can alter the NLS_DATE_FORMAT in sql plus and it sticks but not from the vb in my web pages. Any ideas on how i can force the NLS_DATE_FORMAT to stay dd/mm/yy? Thx.