Advanced Search

Return to Snippet

Revision: 3916
at October 3, 2007 17:51 by rengber
Initial Code 
declare @stringDate varchar(30);
declare @myXmlDate xml
declare @serializedDate datetime
declare @xQuery varchar(100)
set @stringDate = '2007-10-03T11:24:07.003+12:00'
set @myXmlDate = cast('' as xml) --Gets an empty Xml datatype
set @serializedDate = @myXmlDate.value('xs:dateTime(sql:variable("@stringDate"))', 'datetime')
select @serializedDate
Initial URL 
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1920108&SiteID=1
Initial Description 
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
Initial Title 
TSQL Convert Xml DateTime (xs:datetime) to SQL DateTime
Initial Tags 
xml
Initial Language 
SQL