SQL Server Dates and Formatting

[Guest]

OK, this has bugged me for years now with SQL Server and Access. I have a
date field entered in SQL server and I am trying to do a query against it.
The format in SQL server is 'dd/MM/yyyy'. Do I really need to prepare my
query to follow this format or is there another way to query dates in
databases without knowing the format in the database?

Thanks

 

[Jon Skeet [C# MVP]]

OK, this has bugged me for years now with SQL Server and Access. I have a
date field entered in SQL server and I am trying to do a query against it.
The format in SQL server is 'dd/MM/yyyy'. Do I really need to prepare my
query to follow this format or is there another way to query dates in
databases without knowing the format in the database?

Use parameters instead.

See http://www.pobox.com/~skeet/csharp/faq/#db.parameters