Home Forums Article Discussions Article Discussions by Author Discuss content posted by Abhijit Date Puzzle RE: Date Puzzle

  • October 27, 2010 at 11:31 am

    #1243100

    SanDroid (10/27/2010)

    Hugo,

    What if the client application is submitting the data as XML and thier regional setting is English (Cannada) or some other setting not the same as the SQL server? Wouldn't that also change the code needed to safely convert the string to a valid DateTime data type?

    I'm sorry, but I have next to no knowledge of XML, and absolutely no experience with XML. I can't answer this question. Someone else, perhaps?

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/