How to subtract time from Concatenated field

[former_member214784]

Hi all,

I am loading a data from ECC to Oracle using SAP DS,

I concatenated two fields ( date & time ) in one field at target,

ex: A||B = C

from that concatenated field I am trying to subtract 15 hours from time ex: C - 15/24,

but in output I am getting NULL for column C.

If anybody guide me how to overcome this problem.

Thanks & Regards,

Vinodh

[venkataramana_paidi · Accepted solution]

Hi Vinodh,

After concatenation did you convert into datetime or not?   If it is date item , it should work.

Please give me your sample date & time field values.

Thanks & Regards,

Ramana.

[former_member214784 · Accepted solution]

Hi Venkata Ramana,

By using your hint I finished the job, Thank you very much.

to_date(to_char( AAAA(field_name),'YYYY.MM.DD HH:MI:SS'),'YYYY.MM.DD HH:MI:SS') - 15/24

Thanks & Regards,

Vinodh