User bio
404 bio not found
Member since Jul 7, 2020
Posts:
show all 1
Replies:
show all 2
Dave Day · Jul 15, 2020 go to post

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)});

Dave Day · Jul 9, 2020 go to post

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.
Followers:
Dave has no followers yet.
Following:
Dave has not followed anybody yet.