RODBC changing my output

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

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.