I am not seeing converttotimezone() function is not available in azure data factory expression builder, I am trying to save one date column from csv file to oracle column TIMSTAMP(6) WITH TIME ZONE
Tried many things from microsoft url's
I am not seeing converttotimezone() function is not available in azure data factory expression builder, I am trying to save one date column from csv file to oracle column TIMSTAMP(6) WITH TIME ZONE
Tried many things from microsoft url's
Copyright © 2021 Jogjafile Inc.
You can use
toTimestamp()
function in ADF. Because, there is no function calledconverttotimezone()
in azure data factory expression builder.Syntax:
toTimestamp(_<string>_ : any, [_<timestamp format>_ : string], [_<time zone>_ : string]) => timestamp
Example to use the
toTimestamp
function in Azure Data Factory to convert a string value to a timestamp value in thePST
timezone:This will convert the
date_col
to a timestamp value in thePST
timezone. You can use this function for your timezone.