On Wed, 2 Jul 2003 22:28:58 +0100 in comp.databases.ms-sqlserver,
"Peter L.S. Trevor" <ptrevor.trisen@zetnet.co.uk> wrote:

>Hi
>
>We have MS SQL 2000 installed at work (an English local
>government office). We've changed the regional settings so that
>dates are displayed as dd/mm/yy ... but when entering dates in
>SQL queries we still have to use mm/dd/yy. Is there a setting
>which changes SQL command parsing (as opposed to just results
>display)?

This sort of thing should be done in your front end, literal dates in
SQL are always American format, that way the same bit of SQL can work
regardless of country it's executed in.

--
If you try to fail, and succeed, which have you done?

(replace sithlord with trevor for email)