Open topic with navigation

Date/Time Formats With The Unicode Text Adapter

From the Date/Time Format text box, you can select one of the following common formats. Date and time elements are described below.

• yyyy-M-d — Example: 2013-6-23
• M/d/yyyy — Example: 6/23/2013
• d/M/yyyy — Example: 23/6/2013
• dd.MM.yyyy — Example: 23.06.2013
• dd/MM/yyyy — Example: 23/06/2013
• yyyy/M/d — Example: 2013/6/23
• yyyy-MM-dd — Example: 2013-06-23
• yyyyMMddTHH:mmzzz — Example: 20130623T13:22-0500

Alternatively, you can enter the format that reflects your data, using any of the following elements.

Date and Time Formats

Month

• M — The month, from 1 through 12
• MM — The month, from 01 through 12
• MMM — The abbreviated name of the month, for example: Jan, Feb, etc.
• MMMM — The full name of the month., for example: January, February, etc.

Day

• d — The day of the month from 1 through 31
• dd — The day of the month from 01 through 31
• ddd — The standard abbreviation for the day of the week, for example: Mon, Tue, etc.
• dddd — The full name of the day of the week, for example: Monday, Tuesday, etc.

Year

• y — The year from 0 to 99.
• yy — The year from 00 to 99
• yyy — The year with minimum of 3 digits
• yyyy — The year as a four digit number

Hour

• h — The hour using 12-hour clock from 1 – 12
• hh — The hour using 12-hour clock from 01 – 12
• H — The hour using 24-hour clock from 0 – 24
• HH — The hour using 24-hour clock from 00 – 24

Minute

• m — The minute from 0 to 59
• mm — The minute from 00 to 59

Second

• s — The second, from 0 through 59
• ss — The second, from 00 through 59

Other formatting options

• t — The first character of the AM/PM designator.
• tt — The AM/PM designator.
• T — A literal to separate date and time in 8061 or other formats
• z — Hours offset from UTC, with no leading zeros — Example: -5 or +530
• zz — Hours offset from UTC, with leading zero — Example: -05 or +0530
• zzz — Hours and minutes offset from UTC, with leading zeros — Example -0500 or +0530
• g or gg — The period or era (that is AD. or BC)
• K — The zone information

Examples

US standard format

• M/d/yyyy — Example: 6/23/2013
• h:mm:ss tt — Example: 5:45:22 AM (and 5:45:22 PM)

ISO8601 format

• 20130623T0545-05000 using the format yyyymmddTHHmmzzz

Russia and Germany standard format

• dd.MM.yyyy — Example: 23.06.2013
• H:mm:ss — Example: 5:45:22 (and 17:45:22)

UK, Spain, France and Italy standard format

• dd/MM/yyyy — Example: 23/06/2013
• HH:mm:ss — Example: 05:45:22 (and 17:45:22)

China and Japan standard format

• yyyy/M/d — Example: 23/6/2013
• Long Format: yyyy年M月dd日 — Example: 2013年6月23日
• H:mm:ss — Example: 05:45:22 (and 17:45:22)

Korea standard format

• yyyy-MM-dd — Example: 23/6/2013
• Long Format: yyyy년 M월 dd일 (example: 2013년 6월 23일)
• tt h:mm:ss — Example: AM 5:45:22 (and PM 5:45:22)

TIBCO Scribe® Insight Help Library