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
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.