gistfile1.cs

                // date, make into DD MMM YY hh:mm to avoid US/UK data conversion
                // split off the time                
                if (dataValue.IndexOf(' ') < 0 ) dataValue += " 00:00:00";
                string timePart = dataValue.Substring(dataValue.IndexOf(' ')).Trim();
                string datePart = dataValue.Substring(0, dataValue.IndexOf(' ')).Trim();
                // check if it has slash separator
                if (datePart.Contains("/") && timePart.Contains(":"))
                {
                    string[] dateBits = datePart.Split('/');
                    if (dateBits.GetUpperBound(0) == 2)
                    {
                        string MonthName = (new DateTime(2007, int.Parse(dateBits[1]), 1)).ToString("MMM");
                        if (IsDate(dateBits[0] + " " + MonthName + " " + dateBits[2]))
                        {
                            _return = "'" + dateBits[0] + " " + MonthName + " " + dateBits[2] + " " + timePart + "'";
                        }
                        else
                        {
                            _return = "NULL";
                        }
                    }
                    else
                    {
                        _return = "NULL";
                    }
                }
                else
                {
                    if (IsDate(dataValue)) _return = "'" + dataValue + "'"; else _return = "NULL";
                }