current_day <- as.character(ISOdate(2015,4,17)) # 格式转换
sql <- paste("select * from SH WHERE PUBLISHDATE>DATE_FORMAT('", current_day,"','%Y-%m-%d %H:%i:%S')",sep="")
R中mysql数据库datetime格式查询
最新推荐文章于 2024-07-16 05:12:41 发布
current_day <- as.character(ISOdate(2015,4,17)) # 格式转换
sql <- paste("select * from SH WHERE PUBLISHDATE>DATE_FORMAT('", current_day,"','%Y-%m-%d %H:%i:%S')",sep="")