Azure / Azure/Azure-DataFactory
Lookup activity converting String to Date
- Dominant language
- PowerShell
- Stars
- 529
- Forks
- 623
- PR merge metrics
- No merged PRs in 30d
Description
When using a "Stored procedure" query type in a Lookup activity with a string typed parameter the value will be converted to a date in General date/time pattern (long time) format (Specifier "G') for en-US if possible, this results in the value no longer matching the supplied string (Unless the string happens to be that format already).
## Example
### Stored Proc
```SQL
CREATE OR ALTER PROCEDURE [dbo].[ADFBug]
@DateAsString VARCHAR (255)
AS
BEGIN
SELECT @DateAsString as DateAsString,
CASE @DateAsString
WHEN '2023-10-24T00:00:00Z' THEN 'Yes'
ELSE 'No'
END as IsKnownValue
END
GO
```
### Lookup Activity

### Input

### Output

Contributor guide
Assessment
This issue has not been assessed yet.