SSIS Components for CSV

Build 24.0.9060

DateTimeFormat

This setting specifies in which format the datetime values will be written to for CSV files.

Data Type

string

Default Value

""

Remarks

The format should follow a specified pattern:

  1. G - Era designator.
  2. y - Year.
  3. M - Month in year.
  4. w - Results in week in year.
  5. W - Results in week in month.
  6. D - Gives the day count in the year.
  7. d - Day of the month.
  8. F - Day of the week in month.
  9. E - Day name in the week.
  10. u - Day number of week where 1 represent Monday, 2 Tuesday and so on.
  11. a - AM or PM marker.
  12. H - Hour in the day (0-23).
  13. h - Hour in am/pm for 12 hour format (1-12).
  14. K - Hour in am/pm for 12 hour format (0-11).
  15. k - Hour in the day (1-24).
  16. m - Minute in the hour.
  17. s - Second in the minute.
  18. S - Millisecond in the minute.
  19. z - Timezone.
  20. Z - Timezone offset in hours (RFC pattern).
  21. X - Timezone offset in ISO format.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060