April 22, 2009 at 5:05 am
Up until last week all our datetime querying and storage was done with date format dd/mm/yyyy, however now, where as our SQL tables datetime formats are still dd/mm/yyyy, analyzer and enterprise manager throws a conversion error unless the datetime format within our queries is mm/dd/yyyy.
Does anyone have any ideas why this would happen?
Also although its not the end of the world, we have alot of processes and scripts that run with the british date format.
How can I change the date format of the querying clients?
April 22, 2009 at 6:34 am
Chekc following link might useful:
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_6tsql/html/c963e8b4-5a85-4bd0-9d48-3f8da8f6516b.htm
see the following comand too:
SET DATEFORMAT { format | @format_var }
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply