Date conversion from decimal(15,0) to datetime in BODS

[system]

Hi All - Can someone help me with the conversion of date from decimal(15,0) to datetime (yyyy-mm-dd hh24:mi:ss) in BODS 4.2 -

The source dB is HANA where the dates are present as decimal (15,0) and the target dB is Teradata where dates are expected in datetime.

---

Siddhant Tyagi (BOB member since 2013-05-09)

[system]

RESOLVED -

to_char( to_date( cast( 20150523071435, ‘varchar(14)’), ‘YYYYMMDDHH24MISS’),‘YYYY.MM.DD HH24:MI:SS’)

---

Siddhant Tyagi (BOB member since 2013-05-09)

[luchero25]

good mr, if you want value only YYYYMMDD how do in the query sap data services for download table acdoca to gcp