Any idea how to fix this issue of changing output using when using RODBC
You can also use Dual table it changing the output from '20190614051207149' to '20190614051207148'
test <- sqlQuery(o_ch," SELECT CAST('20190614051207149' AS NUMBER(20,0)) FROM dual; ")
head(test)
CAST('20190614051207149'ASNUMBER(20,0))
1 20190614051207148
Thanks