http://snipplr.com/users/rengber/language/sql/tags/DateTime Recent snippets posted on Snipplr.com en-us Thu, 04 Dec 2008 18:27:08 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/3784/simple-technique-to-subtract-years-from-an-oracle-date/

]]> Tue, 25 Sep 2007 20:07:30 GMT http://snipplr.com/view/3784/simple-technique-to-subtract-years-from-an-oracle-date/ http://snipplr.com/view/601/oracle-datetime-interval/

]]> Sun, 30 Jul 2006 14:38:35 GMT http://snipplr.com/view/601/oracle-datetime-interval/