English
  • B2B Data Transformation 10.2
  • All Products

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. XMap
  7. Libraries
  8. Schema Object
  9. Command Line Interface
  10. Scripts
  11. Parsers
  12. Script Ports
  13. Document Processors
  14. Formats
  15. Data Holders
  16. Anchors
  17. Transformers
  18. Actions
  19. Serializers
  20. Mappers
  21. Locators, Keys, and Indexing
  22. Streamers
  23. Validators, Notifications, and Failure Handling
  24. Validation Rules
  25. Custom Script Components

Data Transformation User Guide

Data Transformation User Guide

Back Next

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
.