Data Transformation Engine Functions and Expressions Reference Guide

Functions and Expressions Reference Guide
240
Appendix B - Format Strings
The tables on the following pages present the format strings for numbers, dates
and times for use in functions such as the
CURRENTDATETIME, FROMNUMBER,
TONUMBER, FROMDATETIME, and TODATETIME.
Date and Time Format Strings
You can create custom date and time formats by using the following symbols
based on the format strings described in the following sections.
Time Units
Symbol Description
HH12 Hour (based on a 12-hour clock) in two digits (1-12)
H12 Hour (based on a 12-hour clock) in one or two digits as needed
(1 to 12)
HH24 Hour (based on a 24-hour clock) in two digits (00 to 23)
H24 Hour (based on a 24-hour clock) in one or two digits as needed
(0 to 23)
MM Minute in two digits (00 to 59)
M Minute in one or two digits as needed (0 to 59)
SS Seconds in two digits (00 to 59)
S Second in one or two digits as needed (0 to 59)
AM/PM Meridian (AM/PM)
+/-ZZZZ Hours and minutes before or after Greenwich Mean Time (GMT)
ZZZ Three character abbreviation for time zone (EST, and so on.)