Imprting Date data

[DSRajesh]

Hi

I am facing problem in importing date format data from csv file.
where date format is "2008-09-12".

Please let me know how to resolve this issue?

[priyadarshikunal]

Hi

I am facing problem in importing date format data from csv file.
where date format is "2008-09-12".

Please let me know how to resolve this issue?

First of all tell us what/how are you doing this.

why dont you just try to parse that inside DataStage after reading it as varchar if problem persists.

Regards,

[ArndW]

What exactly is your issue?

[ray.wurlod]

That format should import OK if your date format string is "%yyyy-%mm-%dd", the year component always has four digits, the month component always has two digits, the day component always has two digits, and all the component values are valid in creating a date.