Regional Date Formats

[Cairnsey]

Eventhough my servers regional date format is UK (dd/mm/yy) I'm experiencing seemingly arbitrary date formatting and conversion problems with my select and update queries both from vb/vbscript and query analyser as it appears to use US formats.

Any ideas on what I'm not doing or need to do ?

I believe an option is to use dates within {} to force date format usage but this will inflict quite an overhead on an already completed system.

 

[tlbroadbent]

Check out the article at following link. Be sure to click on the links at the end of the article.

http://tlbroadbent.home.attbi.com/sql/ss_datetime.htm

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.