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(262.40000000000003, 97%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
in sql server my query returns data usingthe where clause as you see here:
where
mydatecolumn >= '2024-01-13 17:15:48.3759630 +00:00' and mydatecolumn < getdate()
In the source copy activity of ADF, this sql does not return data. It only returns data without the where clause. Any suggestions? Does ADF copy activity translate the above whereclause differently than when I run it in management studio of sql server? Thanks
An Azure service for ingesting, preparing, and transforming data at scale.
![](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(60.8, 32%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Does it return all data or no data? It is confusing as first line says, copy activity of ADF, this sql **does not return data**; Second line says, **returns data** without where clause. Can you explain it?
![](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(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
So, without where clause, your query runs fine in copy activity and with where clause it doesn't. Is your source SQL db in on premise? In ADF, the date time is in UTC format..that might be the reason for this behaviour. Can you please post the screenshot with the date column value brought by source in ADF ? I mean, use select mydatecolumn from table name in source tab and do a data preview and share screenshot please?
all ok now. I was using the wrong date thank you
Answer accepted by question author
Hello @arkiboys In order to close this thread I am just reposting your fix here, as the original poster cannot accept his or her own answer
I was using the wrong date. All ok now
After you have corrected the column to correct column, the copy activity worked fine. Please accept this as answer so that it helps the community too. Thanks.