system
#1
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
#2
RESOLVED -
to_char( to_date( cast( 20150523071435, ‘varchar(14)’), ‘YYYYMMDDHH24MISS’),‘YYYY.MM.DD HH24:MI:SS’)
Siddhant Tyagi
(BOB member since 2013-05-09)
good mr, if you want value only YYYYMMDD how do in the query sap data services for download table acdoca to gcp