Table of Contents

Search

  1. Preface
  2. Introduction to Data Transformation
  3. Data Processor Transformation
  4. Wizard Input and Output Formats
  5. Relational Input and Output
  6. Using the IntelliScript Editor
  7. XMap
  8. Libraries
  9. Schema Object
  10. Command Line Interface
  11. Scripts
  12. Parsers
  13. Script Ports
  14. Document Processors
  15. Formats
  16. Data Holders
  17. Anchors
  18. Transformers
  19. Actions
  20. Serializers
  21. Mappers
  22. Locators, Keys, and Indexing
  23. Streamers
  24. Validators, Notifications, and Failure Handling
  25. Validation Rules
  26. Custom Script Components

Supported Formats

Supported Formats

The
DateFormatICU
transformer uses the ICU conventions to represent the date and time format. The following table lists the symbols that you can use in the format patterns. For more information, see:
Pattern Symbol
Meaning
Type
Examples
G
Era designator
Text
AD
y
Year
Number
1996
u
Extended year
Number
-200
, meaning 201 BC
M
Month in year
Text or number
July 07
d
Day in month
Number
10
h
Hour in AM/PM (1-12)
Number
12
H
Hour in day (0-23)
Number
0
m
Minute in hour
Number
30
s
Second in minute
Number
55
S
Fractional second
Number
978
E
Day of week
Text
Tuesday
e
Day of week (local 1-7)
Number
2
D
Day in year
Number
189
F
Day of week in month
Number
2
, meaning the 2nd Wednesday in July
w
Week in year
Number
27
W
Week in month
Number
2
a
AM/PM marker
Text
PM
k
Hour in day (1-24)
Number
24
K
Hour in AM/PM (0-11)
Number
0
z
Time zone
Time
Pacific Standard Time
Z
Time zone (RFC 822)
Number
-0800
v
Time zone (generic)
Text
Pacific Time
g
Julian day
Number
2451334
A
Milliseconds in day
Number
69540000
' '
The text within single quotes is interpreted as a literal string
Text
'Today is 'dd/MM/yyyy
generates output such as
Today is 15/03/2005
''
Literal single quote
Text
'o''clock'
generates the output
o'clock
The count of pattern symbols further determines the format:
  • For text: Four or more pattern symbols means to use the full form. Fewer than four means to use a short or abbreviated form if it exists. For example, if
    EEEE
    produces
    Monday
    ,
    EEE
    produces
    Mon
    .
  • For numbers: The number of pattern symbols is the minimum number of digits. Shorter numbers are zero-padded. For example, if
    m
    produces 6,
    mm
    produces 06.
  • For years: The two-digit year is
    yy
    , and the four-digit year is
    yyyy
    . For example, if
    yy
    produces
    05
    ,
    yyyy
    produces 2005.
  • For months: If
    M
    produces
    1
    , then
    MM
    produces
    01
    ,
    MMM
    produces
    Jan
    , and
    MMMM
    produces
    January
    .
All non-alphabetic characters are interpreted as literals, even if they are not enclosed in single quotes. For example,
dd/MM/yyyy HH:mm
produces
15/03/2005 13:15
.


Updated March 18, 2021