Everything else with SQL and DateTime seems to work so well. i.e. it just works I can declare a DateTime in C# and it will drop straight into SQL with no problems or anything.However, getting the ...

client code rather than SQL code. However, I recognize that there are some situations in which it is best handled in server code. For example, Access, VB, ...