Im trying to read a date column in sequential file stage.
The date format string in the extended properties of the column is specified as:
Code: Select all
%(d,s)/%(m,s)/%yyyy
I got this from the developer guide:
Unable to figure out what I'm missing.If you specified the following date format property:
%(d,s)/%(m,s)/%yyyy
Then the following dates would all be valid:
8/ 8/1958
08/08/1958
8/8/1958
Thanks,
Chetan.C