Datetime Conversion error

By the way, storing date time information in a varchar field is asking for trouble. What if your application stores dates in a US / GB format, but some users have a client with the European date time format. You might get seemingly random errors of the type "The application works the first half of the month, but I get errors during the second half of the month". I can assure you that it is the behaviour of the second half of the month you want, because during the first half of the month, January 4 is returned as April 1 to users having this problem.