Skip to Content
0
Jul 24, 2018 at 09:24 AM

Multi source data foundation date functions

118 Views Last edit Jul 24, 2018 at 09:28 AM 2 rev

Hi all,

I was working with single source data foundation with following sql statements:

select dateadd(second, "RequestCharges"."EXECUTEDTIME" /1000 + 1*60*60, '19700101')

select DATEDIFF(MINUTE, '19700101', dateadd(second, "RequestCharges"."MM2COMPLETEREQUEST" /1000, '19700101'))

select year(dateadd(second, "RequestCharges"."EXECUTEDTIME" /1000 + 1*60*60, '19700101'))

I have on my sql database date fields with type bigint, and with previous functions I'm converting this values into real dates.

Now I need to convert this data foundation into multi source, and with that change all previous sql statement are no longer working.

I was trying to use some idt available functions like "timestampAdd" and "incrementDays" but without any success.

Do you have any idea how I can achieve the same functionality on multi source data foundation?

Many thanks,

Vitor Ramalho