DTS Programming
OutputFormat Property
The OutputFormat property specifies or returns a string that defines the format of the datetime string in the destination column. This format string consists of tokens and delimiters, which define how components of the date and time are to be formatted. The delimiters are explicitly written to the destination column.
Applies To
| DataPumpTransformDateTimeString Object |
Syntax
object.OutputFormat [= formatstring]
| Part | Description |
|---|---|
| object | Expression that evaluates to a DataPumpTransformDateTimeString object. |
| formatstring | String consisting of tokens and delimiters, which define the format of the source column. |
Data Type
String
Modifiable
Read/write
Prototype (C/C++)
HRESULT OutputFormat(BSTR* pRetVal);
HRESULT OutputFormat(BSTR pRetVal);
Remarks
The tokens that can be used in the InputFormat and OutputFormat properties are defined as follows.
| Token | Description |
|---|---|
| yyyy | 4 digit year. |
| yy | 2 digit year. |
| MMMM | Month long name. |
| MMM | Month 3-char abbreviation. |
| MM | 2-digit month number 01..12. |
| M | 1- or 2-digit month number, 1..12. |
| dddd | Day of week long name. |
| ddd | Day of week 3-char abbreviation. |
| dd | 2-digit day number 01..31. |
| d | 1- or 2-digit day number 1..31. |
| hh | 2-digit hours 01..12. |
| h | 1- or 2-digit hours 1..12. |
| HH | 2-digit hours 00..23. |
| H | 1- or 2-digit hours 0..23. |
| mm | 2-digit minutes 00..59. |
| m | 1- or 2-digit minutes 0..59. |
| ss | 2-digit seconds 00..59. |
| s | 1- or 2-digit seconds 0..59. |
| f[f[f...]]] | Fraction of second, in the number of digits as "f"s specified. |
| tt | Symbol for A.M. or P.M. |
The property also can be referenced through the TransformServerProperties collection with the following code:
Set transprops = transform.TransformServerProperties
transprops("OutputFormat") [= formatstring]