The Fields tab on the Text File As A Source or Text File As A Target Connection dialog has an option to set the data type for the selected field. If you choose DateTime, you must enter the format for the Date/Time in the Date Format field using one of the following formats:
- 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
You can enter a format that reflects your data, using any of the following elements.
Bạn đang xem: Text Connector DateTime Formats
Date And Time Formats
Format Definition
Month
M
Month, from 1 through 12
MM
Two digit month, from 01 through 12
MMM
Abbreviated name of the month, for example: Jan, Feb, etc.
MMMM
Full name of the month, for example: January, February, etc.
Day
d
Day of the month from 1 through 31
dd
Day of the month from 01 through 31
ddd
Standard abbreviation for the day of the week, for example: Mon, Tue, etc.
dddd
Full name of the day of the week, for example: Monday, Tuesday, etc.
Year
y
Year from 0 to 99
yy
Year from 00 to 99
yyy
Xem thêm : Ăn chay có ăn trứng hay uống sữa được không?
Year with minimum of 3 digits
yyyy
Year as a four digit number
Hour
h
Hour using 12-hour clock from 1 – 12
hh
Hour using 12-hour clock from 01 – 12
H
Hour using 24-hour clock from 0 – 24
HH
Hour using 24-hour clock from 00 – 24
Minute
m
Hour using 12-hour clock from 1 – 12
mm
Hour using 12-hour clock from 01 – 12
Second
s
Second, from 0 through 59
ss
Second, from 00 through 59
Other
t
First character of the AM/PM designator
tt
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
Period or era, such as A.D.
K
Zone information
DateTime 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
Related Topics
Source Text Connection — Fields Tab
Target Text Connection — Fields Tab
Nguồn: https://luatduonggia.edu.vn
Danh mục: Tổng hợp