| Excerpt |
|---|
Using date-time fields in Load Replace filter settings – Source Field and Target Value or Constant. Use of CONVERT(DATE, GETDATE()) instead of just GETDATE(). |
GETDATE() – Key Points
CONVERT(DATE, GETDATE()) Preferred Over GETDATE()
Example: When run on | ||
|---|---|---|
T-SQL Expression | DATEADD(DAY,-2,GETDATE()) | DATEADD(DAY,-2,CONVERT(DATE, GETDATE()) |
returns value |
| |
data type | datetime | date |
...