Viewing 2 posts - 1 through 2 (of 2 total)
SET DATEFORMAT dmy
is an option.
You can as well change your date format to ANSI
i.e. 19/10/2004 becomes '20041019'
SQL server converts this to date irrespective of the date format at...
October 20, 2004 at 2:46 am
#527282
the only way out is to store those items as session variables,
eg assuming you have var1, var2, var3 .. varn
you can have
session("v1") = var1
session("v2")= var2
session("v3") = var3
...
session("vn") = varn
then...
June 23, 2004 at 1:44 am
#511565