Date and time formatting

Returns the year with century as a decimal number.

strftime(dateField, "%Y") results in "1993"

Returns the year without century as a decimal number (00-99).

strftime(dateField, "%y") results in "93"

Returns year / 100 as a decimal number; single digits are preceded by a zero.

strftime(dateField, "%C") results in "19"

Returns the month as a decimal number (01-12).

strftime(dateField, "%m") results in "02"

Returns the full national month name.

strftime(dateField, "%B") results in "February"

Returns the abbreviated national month name.

strftime(dateField, "%b") results in "Feb"

Returns the week number of the year (Sunday as the first day of the week) as a decimal number (00-53).

strftime(dateField, "%U") results in "05"

Returns the week number of the year (Monday as the first day of the week) as a decimal number (01-53).

strftime(dateField, "%V") results in "05"

Returns the week number of the year (Monday as the first day of the week) as a decimal number (00-53).

strftime(dateField, "%W") results in "05"

Returns the full national weekday name.

strftime(dateField, "%A") results in "Tuesday"

Returns the abbreviated national weekday name.

strftime(dateField, "%a") results in "Tue"

Returns the day of the month as a decimal number (01-31).

strftime(dateField, "%d") results in "02"

Returns the day of the month as a decimal number (1-31).

strftime(dateField, "%e") results in " 2"

Returns the day of the year as a decimal number (001-366).

strftime(dateField, "%j") results in "033"

Returns the weekday (Monday as the first day of the week) as a decimal number (1-7).

strftime(dateField, "%u") results in "5"

Returns the weekday (Sunday as the first day of the week) as a decimal number (0-6).

strftime(dateField, "%w") results in "2"

Returns the hour (24-hour clock) as a decimal number (00-23).

strftime(dateField, "%H") results in "06"

Returns the hour (24-hour clock) as a decimal number (0-23).

strftime(dateField, "%k") results in " 6"

Returns the hour (12-hour clock) as a decimal number (01-12).

strftime(dateField, "%I") results in "06"

Returns the hour (12-hour clock) as a decimal number (1-12).

strftime(dateField, "%l") results in " 6"

Returns the minute as a decimal number (00-59).

strftime(dateField, "%M") results in "00"

Returns the second as a decimal number (00-60).

strftime(dateField, "%S") results in "00"

Returns the millisecond as a decimal number (000-999).

strftime(dateField, "%S") results in "000"

Returns the national representation of either "ante meridiem" (a.m.) or "post meridiem" (p.m.).

strftime(dateField, "%p") results in "AM"

Returns the national representation of time and date.

strftime(dateField, "%c") results in "Tue Feb 2 06:00:00 1993"

Returns the national representation of the time.

strftime(dateField, "%X") results in "06:00:00"

Returns the national representation of the date.

strftime(dateField, "%x") results in "02/02/93"

Returns the time zone name.

strftime(dateField, "%Z") results in "-0500"

Returns the time zone offset from UTC.

strftime(dateField, "%z") results in "-0500"

Returns a newline (\n).

strftime(dateField, "%n") results in "\n"

Returns a tab.

strftime(dateField, "%t") results in "\t"

Returns a %.

strftime(dateField, "%%") results in "%"

Equivalent to %Y-%m-%d.

strftime(dateField, "%F") results in "1993-02-02"

Equivalent to %m/%d/%y.

strftime(dateField, "%D") results in "02/02/93"

Equivalent to %H:%M.

strftime(dateField, "%R") results in "06:00"

Equivalent to %I:%M:%S %p.

strftime(dateField, "%r") results in "06:00:00 AM"

Equivalent to %H:%M:%S.

strftime(dateField, "%T") results in "06:00:00"

Equivalent to %e-%b-%Y.

strftime(dateField, "%v") results in " 2-Feb-1993"