Date Conversion

[DSguru2B]

O ok. Always love your "to the point" answers :D
There has to be an explanation for this then. Thats the best that I could come up with.

[chulett]

I'd have to see the actual job and have access to the source data to know what was going on. I just know it ain't that.

[sri75]

Thanks for all of your inputs and suggestions.

finally I stick with this derivation
Iconv(DSLink71.HIRED, "DMDY").

I have another question , in .csv file the values of the column is '11/3/2007' in this format.but when reading from sequential file it is reading only last 2 digits of the year.I want to read all 4 digits.Can you plesae let me know where to make changes in seq file to get full year

Thanks

[chulett]

What is your datatype in the Sequential file stage? Use a Varchar if you don't want the reader to muck with the values.

[sri75]

HI thanks for all of your inputs and suggestions

I stick with this derivation

Iconv(DSLink71.HIRED, "DMDY[2,2,4]")

I have another question,in .csv file the format of the column looks like this
'11/03/2007', but when I am reading from seq file, it is showing only 2 digits o fthe year.Can you please tell me what needs to be done on seq file side to get all 4 digits


Thanks

[sri75]

sorry, submitted 2 times

[sri75]

sorry, submitted 2 times

[sri75]

changed to varchar, still it is showing 2 digits

[DSguru2B]

Is it really showing two digits or the display of that particular column is set to 8 instead of 10?

[sri75]

something goofy happened, when I moved file from windows to Unix.
I copied the file again to unix ,now it is showing 4 digits