I am using the code below to set tyhe NLS_DATE_FORMAT
Set AltSess = Server.CreateObject("ADODB.Connection")
AltSess.open strConn
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.

Hopefully these will help:

How do I delimit/format dates for database entry?
http://www.aspfaq.com/show.asp?id=2023

Could I get a little help with dates?
http://www.aspfaq.com/show.asp?id=2040