Date and Time Formats

Date Data Types

Fast parse supports the following string formats for date data:

• Date formats that include leading white spaces. For example, the value " 2004- 02-03" is valid.

• ISO 8601 formats, as listed in the following table:

  Format	Description
  YYYYMMDD YYYY-MM-DD	Basic and extended formats for a four-digit year, a two-digit month, and a two-digit day. In the extended format, the date parts are separated by a hyphen (-).
  YYYY-MM	Basic and extended reduced precision formats for a four-digit year and a two-digit month. In the extended format, the date parts are separated by a hyphen (-).
  YYYY	Reduced precision format is a four-digit year.

Fast parse does not support the following formats for date data:

• Alphabetical month values. For example, the date format Oct-31-2003 is not valid.

• Ambiguous formats such as DD-MM-YYYY and MM-DD-YYYY. For example, the dates 03-04-1995 and 04-03-1995 are not valid.

• Basic and extended truncated formats for a four-digit calendar year and a three-digit day within a year, YYYYDDD and YYYY-DDD.

• Basic and extended formats for a four-digit year, a two-digit number for the week of the year, and a one-digit number for the day of the week, YYYYWwwD and YYYY-Www-D

• Basic and extended truncated formats for a year and week date are a four-digit year and a two-digit number for the week, YYYWww and YYYY-Www

Fast parse outputs the data as DT_DBDATE. Date values in truncated formats are padded. For example, YYYY becomes YYYY0101.

For more information, see Integration Services Data Types.

Time Data Type

Fast parse supports the following string formats for time data:

• Time formats that include leading white spaces. For example, the value " 10:24" is valid.

• 24-hour format. Fast parse does not support the AM and PM notation.

• ISO 8601 time formats, as listed in the following table:

  Format	Description
  HHMISS HH:MI:SS	Basic and extended formats for a two-digit hour, a two-digit minute, and a two-digit second. In the extended format, the time parts are separated by a colon (:).
  HHMI HH:MI	Basic and extended truncated format for a two-digit hour and a two-digit minute. In the extended format, the time parts are separated by a colon (:).
  HH	Truncated format for a two-digit hour.
  00:00:00 000000 0000 00 240000 24:00:00 2400 24	The format for midnight.

• Time formats that specify a time zone, as listed in the following table:.

  Format	Description
  +HH:MI +HHMI	Basic and extended formats that indicate the number of hours and minutes that are added to Coordinated Universal Time (UTC) to obtain the local time.
  -HH:MI -HHMI	Basic and extended formats that indicate the number of hours and minutes that are subtracted from UTC to obtain the local time.
  +HH	Truncated format that indicates the number of hours that are added to UTC to obtain the local time.
  -HH	Truncated format that indicates the number of hours that are subtracted from UTC to obtain the local time.
  Z	A value of 0 that indicates the time is represented in UTC.

  The formats for all time and date/time data can include a time zone element. However, the system ignores the time zone value except when the data is of type DT_DBTIMESTAMPOFFSET. For more information, see Integration Services Data Types.

  In formats that include a time zone element, there is no space between the time element and the time zone element, as shown in the following example:

  HH:MI:SS[+HH:MI]

  The brackets in the previous example indicate that the time zone value is optional.

• Time formats that include a decimal fraction, as listed in the following table:

  Format	Description
  HH[.nnnnnnn]	n is a value between 0 and 9999999 that represents a fraction of hours. The brackets indicate that this value is optional. For example, the value 12.750 indicates 12:45.
  HHMI[.nnnnnnn] HH:MI[.nnnnnnn]	n is a value between 0 and 9999999 that represents a fraction of minutes. The brackets indicate that this value is optional. For example, the value 1220.500 indicates 12:20:30.
  HHMISS[.nnnnnnn] HH:MI:SS[.nnnnnnn]	n is a value between 0 and 9999999 that represents a fraction of seconds. The brackets indicate that this value is optional. For example, the value 122040.250 indicates 12:20:40.15.

  Note

  The fraction separator for the time formats in the previous table can be a decimal or a comma.

• Time values that include a leap second, as shown in the following examples:

  23:59:60[.0000000]

  235960[.0000000]

Fast parse outputs the strings as DT_DBTIME and DT_DBTIME2. Time values in truncated formats are padded. For example, HH:MI becomes HH:MM:00.000.

For more information, see Integration Services Data Types.

Date/Time Data Type

Fast parse supports the following string formats for date/time data:

• Formats that include leading white spaces. For example, the value " 2003-01-10T203910" is valid.

• Combinations of valid date formats and valid time formats separated by an uppercase T, and valid time zone formats, such as YYYYMMDDT[HHMISS][+HH:MI]. The time and time zone values are not required. For example, "2003-10-14" is valid.

Fast parse does not support time intervals. For example, a time interval identified by a start and end date and time in the format YYYYMMDDThhmmss/YYYYMMDDThhmmss cannot be parsed.

Fast parse outputs the strings as DT_DATE, DT_DBTIMESTAMP, DT_DBTIMESTAMP2, and DT_DBTIMESTAMPOFFSET. Date/time values in truncated formats are padded. The following table lists the values that are added for missing date and time parts.

For more information, see Integration Services Data Types.

See Also

Concepts