CODEWITHSUNDEEP
etlazure-data-factory
Oki Kuswanda
Oki Kuswanda

Reputation: 73

Azure Data Factory todate Day -1

I have some Expression to get date UTC+7 (Jakarta time) like this

toDate(toString((currentUTC()+ hours(7))),'yyyy-MM-dd HH:mm:ss')

and for example output is:

2021-12-28 20:15:23

I want from this expression is add day -1, and the output is:

2021-12-27 20:15:23

many big thanks for answer the question

Upvotes: 0

Views: 101

Answers (1)

Satya V
Satya V

Reputation: 4174

You could try the below :

addDays(toDate(toString((currentUTC()+ hours(7))),'yyyy-MM-dd HH:mm:ss'),-1)

Upvotes: 2

Related Questions