This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 53%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
I only need to take the time part from the 'Timestamp type source attribute' and load it into a dedicated SQL pool table (Time datatype column). But I don't find a time function within the expression builder in ADF, is there a way I can do it?
-What did I do? -I took the time part from the source attribute using substring and then tried to load the same into the destination table, when I do the destination table inserted null values as the column at the destination table is set to time datatype.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Hello @Vivek Komarla Bhaskar ,
If @Nasreen Akter 's suggestion solved your issue, please mark as accepted answer.
Thanks
Martin
Hi, This didn't help in resolving the issue. I still get null when trying to insert into the synapse destination table
would you please try toTimestamp and toString functions. Thanks!
toString(toTimestamp(field1, 'yyyy-MM-dd HH:mm:ss'), 'HH:mm:ss')
Hi nasreen-akter,
Thanks for your reply!
I want the output of column1 in your example to be a Time datatype, in your case too its still a String datatype and when loading this into a dedicated pool table into a column which is Time datatype it will only insert NULL values.
Would you please try to map the full DateTime column to the time field e.g.,
_col1 --> toTimestamp(field1, 'yyyy-MM-dd HH:mm:ss')
_col1 >> AtTime24Hr
and see if you get the time. Just make sure you have SINK --> Options --> Allow schema drift option is checked.
Thanks
Hi Nasreen,
Thanks for your reply
Hope my question is clear, I'm only after the time value from a data time source field. toTimestamp will return Data+Time.
@Vivek Komarla Bhaskar , yes, I understand that you have AtTime24Hr as time in SQL