Hi there,

When I use LLBLGen to output the SQL for comparing a date column and a DateTime object's value, it puts the format of the DateTime's value in such a way that different databases can make sense of it. Even when one database would accept this.. '23/12/2005' where as the other would throw an exception because it wanted this.. '12/23/2005'.

So the question is, if I am generating raw SQL without LLBLGen, how can I get a DateTime's value formatted in the same way that LLBLGen does?

Is it even LLBLGen doing it or is it delegating to the SQLClient objects of .net?

Cheers, I

If you are using a SQLParameter of a "SqlDbType.DateTime" type you won't face any problem saving your DateTime variable into a SQL datetime field

Thanks.

I suppose I should have been using SqlParameters anyway to avoid injection attacks.