http://snipplr.com/users/rengber/tags/conversion Recent snippets posted on Snipplr.com en-us Wed, 15 Oct 2008 17:12:33 GMT http://snipplr.com/view/3827/tsql-convert-xml-datetime-xsdatetime-to-sql-datetime/ This is as small as this can go: 'xs:dateTime(sql:variable("@stringDate"))' It needs to be a literal string for the Value() function. Xml Datatype http://msdn2.microsoft.com/en-us/library/ms189887.aspx Sql:Variable() Function http://msdn2.microsoft.com/en-us/library/ms188254.aspx 'xs:dateTime( val )' http://www.w3schools.com/xpath/xpath_functions.asp#datetime Xml Datatype Methods http://msdn2.microsoft.com/en-us/library/ms190798.aspx

]]> Wed, 03 Oct 2007 17:51:34 GMT http://snipplr.com/view/3827/tsql-convert-xml-datetime-xsdatetime-to-sql-datetime/ http://snipplr.com/view/2401/converting-integers-to-and-from-binary/

]]> Tue, 27 Mar 2007 19:21:33 GMT http://snipplr.com/view/2401/converting-integers-to-and-from-binary/