[问题类型]:
程式咨询(我想用R 做某件事情,但是我不知道要怎么用R 写出来)
[软件熟悉度]:
入门(写过其他程式,只是对语法不熟悉)
[问题叙述]:
我想使用R的RODBC跟ORACLE数据库相联,并且捞回上个月月份的资料。
在我的资料表表单中,有一栏ACTDATE记录时间,R读取时是POSIXct格式
假设我想抓上个月份的资料,我该怎么做?
[程式范例]:
程式不长我直接贴
Sys.setenv(TZ = "UTC") #设定时间
dataframe <- sqlQuery(conn, "SELECT ACTDATE,SECTOR,STD,STA
FROM TABLE
where months(ACTDATE) = months(Sys.Date())-1
Order by ACTDATE ")
感觉一定是怪怪的,但也不知该如何改
[环境叙述]:
sessionInfo()
R version 3.3.3 (2017-03-06)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1
locale:
[1] LC_COLLATE=Chinese (Traditional)_Taiwan.950 LC_CTYPE=Chinese
(Traditional)_Taiwan.950
[3] LC_MONETARY=Chinese (Traditional)_Taiwan.950 LC_NUMERIC=C
[5] LC_TIME=Chinese (Traditional)_Taiwan.950
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] mail_1.0 xlsx_0.5.7 xlsxjars_0.6.1 rJava_0.9-8 RODBC_1.3-14
loaded via a namespace (and not attached):
[1] tools_3.3.3
[关键字]:
RODBC