.NET SqlClient and Dates

[Mondeo]

I have this statement

 

SELECT * FROM vwAllMatrixVehicles WHERE created >= '2007/8/9'

 

Using query analyser in sql management studio it returns about 80 rows.

 

Trying to use it in ASP.NET with the SqlCommand class the same statement returns 0 rows.

 

I've double checked my code, its fine. If I replace the select statement with something else that doesn't use a date its fine.

 

Does SqlClient handle dates differently somehow?

 

Thanks

[PlausiblyDamp]

It's probably down to the date format being interpreted differently between ASP.Net and SQL Management studio.

 

Try putting the month as a full string (i.e. either August or September depending) and see if that alters the results. Also how is the string being generated in the ASP.Net page?

[Mondeo]

Originally I was just building the string with concatenation, but for this example I just put it directly into a string

 

Dim sql as string = "SELECT * FROM vwAllMatrixVehicles WHERE created >= '2007/8/9'"

 

Its very puzzling???

[PlausiblyDamp]

What do you get if you tru

[highlight=sql]

Dim sql as string = "SELECT * FROM vwAllMatrixVehicles WHERE created >= '2007/9/8'"

[/highlight]

[Mondeo]

Spot on. If I reverse the month and day it works fine. SqlClient must split the string up and pass the values individually, perhaps as parameters.

 

Thanks a lot

[PlausiblyDamp]

Rather than concatenating strings use a parameterized query - that way you don't need to worry about different systems trying to interpret the strings correctly.