string to date conversion

[kollurianu]

I have input value in the file as varchar(10) as yyyymmdd /yymmdd , I got to insert into the oracle database as date field.

Before writing to table I am just converting the string to date format and writing to a file for testing purposes which is not working and job is aborting.Following the function used for conversion.

StringToDate(DSLink92.PROCESS_DATE, "%yyyy-%mm-%dd%" )

Any inputs greatly appreciated.

[kollurianu]

Now the function is working with some warnings
as below:

APT_CombinedOperatorController(1),0: Conversion error calling conversion routine date_from_string data may have been lost

And I have the Null field value set to 1950-01-01 to the date fields in the column properties.

Is that the right way set Null properties on the target file side.

Thank you all.

[kollurianu]

All the Null dates are being written as ********** in the output file.

[kumar_s]

if you input format is differnt use the derivatin as StringToDate(DSLink92.PROCESS_DATE, "%yy%mm%dd%" )

[savis]

Hi,

hope this helps..

If Len(StageVar)=6 Then StringToDate(StageVar,"%2000yy%mm%dd") Else StringToDate(StageVar,"%yyyy%mm%dd")

Thanks,
Savis