BizBert - Understanding the BizTalk Mapper: Part 6

Wednesday, February 13, 2008

Understanding the BizTalk Mapper: Part 6 - Date/Time Functoids

XSLT v1.0 has no support for Date/Time values, whilst XSLT v2.0 has full support.
Therefore it's not surprising that your only option is to use C#'s rich support for Date/Time values.
And this is why all of the functoids in this category emit inline C#.

For each functoid I've shown:

Whether XSLT or C# is emitted
Whether an XSLT equivalent exists
The XSLT or C# emitted by the functoid
Where C# is emitted, the equivalent XSLT to achieve the same functionality (in both XSLT v1.0 and v2.0)

Functoids covered in this category:

Add Days	Time
Date	Common Code
Date and Time

Date/Time Functoids
Note: XSLT 1.0 has no built-in Date/Time functions, whereas XSLT 2.0/XPath 2.0 does.
	Add Days
	Generates: C#	Has XSLT Equivalent: in 2.0 only
	Emitted Code: public string DateAddDays(string date, string days) { string retval = ""; double db = 0; if (IsDate(date) && IsNumeric(days, ref db)) { DateTime dt = DateTime.Parse(date); int d = (int)db; dt = dt.AddDays(d); retval = dt.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); } return retval; }
	XSLT 1.0 Equivalent: (none)
	XSLT 2.0 Equivalent: xs:dateTime('2007-12-12') + xdt:dayTimeDuration('PxD') Where x (in dayTimeDuration()) is number of days to add e.g. 5 days would be 'P5D'

	Date
	Generates: C#	Has XSLT Equivalent: in 2.0 only
	Emitted Code: public string DateCurrentDate() { DateTime dt = DateTime.Now; return dt.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); }
	XSLT 1.0 Equivalent: (none)
	XSLT 2.0 Equivalent: fn:current-date()

	Date and Time
	Generates: C#	Has XSLT Equivalent: in 2.0 only
	Emitted Code: public string DateCurrentDateTime() { DateTime dt = DateTime.Now; string curdate = dt.ToString("yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture); string curtime = dt.ToString("T", System.Globalization.CultureInfo.InvariantCulture); string retval = curdate + "T" + curtime; return retval; }
	XSLT 1.0 Equivalent: (none)
	XSLT 2.0 Equivalent: fn:current-dateTime()

	Time
	Generates: C#	Has XSLT Equivalent: in 2.0 only
	Emitted Code: public string DateCurrentTime() { DateTime dt = DateTime.Now; return dt.ToString("T", System.Globalization.CultureInfo.InvariantCulture); }
	XSLT 1.0 Equivalent: (none)
	XSLT 2.0 Equivalent: fn:current-date()

	Common Code (this is common code used by all the date/time functoids)
	public bool IsNumeric(string val) { if (val == null) { return false; } double d = 0; return Double.TryParse(val, System.Globalization.NumberStyles.AllowThousands \| System.Globalization.NumberStyles.Float, System.Globalization.CultureInfo.InvariantCulture, out d); } public bool IsNumeric(string val, ref double d) { if (val == null) { return false; } return Double.TryParse(val, System.Globalization.NumberStyles.AllowThousands \| System.Globalization.NumberStyles.Float, System.Globalization.CultureInfo.InvariantCulture, out d); } public bool IsDate(string val) { bool retval = true; try { DateTime dt = Convert.ToDateTime(val, System.Globalization.CultureInfo.InvariantCulture); } catch (Exception) { retval = false; } return retval; }

Wednesday, February 13, 2008 3:17:24 PM (GMT Standard Time, UTC+00:00)

Comments are closed.