Hey,
The below link can help you :
https://azurelib.com/datetime-conversions-in-azure-data-factory/
You can even use the combination of above function and concat as well.
And for prevent date, use dateadd function
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi Can you please let me know how to get the expression done in ADF pipeline to get the date time format in '2021-11-01 06:00' format.
And also to get previous date with same format please.
Hey,
The below link can help you :
https://azurelib.com/datetime-conversions-in-azure-data-factory/
You can even use the combination of above function and concat as well.
And for prevent date, use dateadd function
Hi, Thank you for the links.
I am having trouble concating variables into this query. Please help
SELECT '411D2DF4-0E28-488B-A95D-ghjkhjkhjkhjkjk' as Site,Periodendtime as utcSampledatetime,Periodendtime as Sampledatetime, [test.test.test] as Feed, [test.test.test] as Prim_Prod,[test.test.test] as Sec_Prod
from
(SELECT PeriodEndTime, sourcefqn, quantity
from [testExt].[dbo].fn_test_Movements_GetFiltered
where SourceFQN in ('test.test.test.test', 'test.test.test.test', 'test.test.test')) AS X
PIVOT (MAX(QUANTITY) FOR sourcefqn IN ([test.test.test], [test.test.test1],[test.test.test2])) AS PIV
Click to vote
0 Votes"
0
AP-9104 answered · 2 hours ago
Hi, Thank you for the links.
I am having trouble concating variables into this query. Please help
SELECT '411D2DF4-0E28-488B-A95D-ghjkhjkhjkhjkjk' as Site,Periodendtime as utcSampledatetime,Periodendtime as Sampledatetime, [test.test.test] as Feed, [test.test.test] as Prim_Prod,[test.test.test] as Sec_Prod
from
(SELECT PeriodEndTime, sourcefqn, quantity
from [testExt].[dbo].fn_test_Movements_GetFiltered
where SourceFQN in ('test.test.test.test', 'test.test.test.test', 'test.test.test')) AS X
PIVOT (MAX(QUANTITY) FOR sourcefqn IN ([test.test.test], [test.test.test1],[test.test.test2])) AS PIV