Check that

[pradeep_nov18]

Hi ALL,

I have requirement

Input(SRC DATATYPE:CHAR(16)) Required(TGT DATATYPE:date(10)

INPUT OUTPUT
00000000******** NULL
20080701******** 2008-07-01

I have give derviation in the column

If SAP_ATL_COST_SAVING_copy_ln2.ZPRT_COSTSAVINGS_BEDAT = '00000000 ' Then Setnull() Else StringToDate(SAP_ATL_COST_SAVING_copy_ln2.ZPRT_COSTSAVINGS_BEDAT [1,4] : "-" : SAP_ATL_COST_SAVING_copy_ln2.ZPRT_COSTSAVINGS_BEDAT [5,2] : "-" : SAP_ATL_COST_SAVING_copy_ln2.ZPRT_COSTSAVINGS_BEDAT [7,2],"%yyyy-%mm-%dd")

BUT the valid data(for eg:20080701********) output is as expected but if the value is (00000000********) than it is takin default in teradata side

please let me how to achieve the required Output and correct me if i am wrong

Thanks in Advance

[chulett]

Check that?

[pradeep_nov18]

Check that?

derivation which has posted not working.

[chulett]

I know. Just making a point that you need to do a better job of picking Subjects for your posts. "Check that" and "Hi all"? Please.

[ray.wurlod]

And posting the same question over and over is frowned upon.