User bio
404 bio not found
Member since Jul 7, 2020
Posts:
Replies:
I can't disable quoting of identifiers with the Replicate tool. However, I can run both quoted and unquoted versions of the query successfully with Microsoft SSIS, that is whilst using the same ODBC driver.
Certifications & Credly badges:
Dave has no Certifications & Credly badges yet.
Global Masters badges:
Dave has no Global Masters badges yet.
Followers:
Dave has no followers yet.
Following:
Dave has not followed anybody yet.
I managed to solve the problem as follows
-- current day
WHERE (Timestamp >= {fn CONVERT(CURRENT_DATE,SQL_TIMESTAMP)}
AND Timestamp < {fn CONVERT(DATEADD(dd,1,CURRENT_DATE),SQL_TIMESTAMP)} )
-- previous day
WHERE
(Timestamp >= {fn CONVERT(DATEADD(dd,-1,CURRENT_DATE),SQL_TIMESTAMP)}
AND Timestamp < {fn CONVERT(CURRENT_DATE,SQL_TIMESTAMP)});