Hi,

This is usually caused by differing Windows locales in the different SQL environments.

To format the date in c# use the DateTime.ToString() method :

DateTime MyDate = DateTime.Now;

String FormattedDate = MyDate.ToString("yyyyMMdd hhmmss");

You...

One way I have managed to convince "we've always done it this way" types (or their bosses) is to show them the MS SQL Best Practices Analyzer.

Be warned though, this...