Hi Joel Prescilla , Thankyou for using Microsoft Q&A platform and thanks for posting your question here. From the description of your query, it seems you are trying to use GETDATE() function in the SSIS package which is being executed in ADF pipeline. However, you want to get the date in your desired timeZone. Please correct me if the understanding is wrong.
GetDate() Function Returns the current date of the system in UTC time (Universal Time Coordinate) using a DT_DBTIMESTAMP format.
- If you want to convert the date value to desired timeZone then you can use the following expression in ADF pipeline:
@convertTimeZone(utcnow(),'UTC','Time Zone Name')
Kindly check the Microsoft Time Zone Index Values here: Microsoft Time Zone Index Values - Alternate approach is to use fromUTC() funtion to convert the UTC time to a different timezone . For Example:
fromUTC(currentUTC(), 'Asia/Seoul')
- Alternate approach in SQL Server: Convert values between different time zones Hope it helps. Kindly accept the answer if it's helpful.