Loading TOC...
XQuery fn:format-dateTime

MarkLogic 12 EA 1 Product Documentation
fn.formatDateTime

fn.formatDateTime(
   value as Date,
   picture as String,
   [language as String],
   [calendar as String],
   [country as String]
) as String

Summary

Returns a formatted dateTime value based on the picture argument. This is an XSLT function, and it is available in XSLT, XQuery 1.0-ml, and Server-Side JavaScript.

Parameters
value The given dateTime $value that needs to be formatted.
picture The desired string representation of the given dateTime $value. The picture string is a sequence of characters, in which the characters represent variables such as, decimal-separator-sign, grouping-sign, zero-digit-sign, digit-sign, pattern-separator, percent sign and per-mille-sign. For details on the picture string, see http://www.w3.org/TR/xslt20/#date-picture-string.
language The desired language for string representation of the dateTime $value.
calendar The only calendar supported at this point is "Gregorian" or "AD".
country $country is used the specification to take into account country specific string representation.

Usage Notes

Dates before October 15, 1582 (the start of the Gregorian calendar) will not return the correct dateTime value.

If the specified picture string includes a fractional second width that is seven or more decimal places, then the fractional seconds are truncated (not rounded) on the seventh and greater width.

Example

   fn.formatDateTime(fn.currentDateTime(),
                 "[Y01]/[M01]/[D01] [H01]:[m01]:[s01]:[f01]")
   =>
   14/12/05 10:37:25:63

  fn.formatDateTime(fn.currentDateTime(),
                 "[Y0001]/[M01]/[D01] [H01]:[m01]:[s01]:[f01]","en","AD","US")
   =>
   2014/12/05 10:40:02:16

Stack Overflow iconStack Overflow: Get the most useful answers to questions from the MarkLogic community, or ask your own question.