by Darren Green
28 Oct 2008 07:58
Date Parts Expressions support a range of date related functions such as DATEADD, with the same basic syntax to that found in T-SQL. Whilst the familiarity is very helpful, the difference that catches me out is the format of date part which must be quoted. T-SQL allows this: DATEADD(n, -10, GETDATE())
DATEADD(mi, -10, GETDATE())
DATEADD(minute, -10, GETDATE())
The SSIS equivalent is:
DATEADD("n", -10, GETDATE())
DATEADD("mi", -10, GETDATE())
DATEADD("minute", -10, GETDATE())
Related functions that use the same date part tokens -
DATEAD...
[More]