Output column will be decimal(38,0) datatype. I have faced a scenario of input date column coming from a JDE source and output will be loaded into a target in which date has to be stored as milliseconds.Īfter doing a search I got to know that epoch time is the format for storing date in millisecond.Epoch time, also known as Unix time, is the number of seconds that have elapsed since January 1, 1970įor converting JDE date to standard date format we can use JDE_Date() function.īut there is no inbuilt function in SAP DataServices to convert date into epoch time.ġ.For converting JDE date to standard date use JDE_Date()Ģ.For converting standard date in to epoch date,use belowĭate_diff(to_date(‘1970.01.01′,’YYYY.MM.DD’),To_Date(Query.standard_date,’YYYY.MM.DD’),’DD’)*86400000.0
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |