search for: begtime

...require(RMySQL) startdatetime<-"2009-04-04 01:00:00" connect <- dbConnect(MySQL(),user="xxxxx",password="xxxxxx",dbname="xxxxx",host="xxx.xxx.xxx.xxx") forecast <- dbSendQuery(connect, statement=paste("SELECT ICE FROM table1 WHERE BEGTIME >= 'startdatetime'")) # doesnt read variable or forecast <- dbSendQuery(connect, statement=paste("SELECT ICE FROM table1 WHERE BEGTIME >="startdatetime)) # space error but this seems to work forecast <- dbSendQuery(connect, statement=paste("SELECT ICE FRO...

...sing both the unique & then the !duplicated functions but it just hangs there & I get no output. Does anyone know how to solve this? This is how I tried to do it in R: detail3 <- [!duplicated(c(detail2$TDATE,detail2$FIRM,detail2$CM,detail2$BRANCH, detail2$BEGTIME, detail2$ENDTIME,detail2$OTYPE,detail2$OCOND, detail2$ACCTYP ,detail2$OSIDE,detail2$SHARES,detail2$STOCKS, detail2$STKFUL)),] detail3 <- unique(detail2[,c(detail2$TDATE,detail2$FIRM,detail2$CM,detail2$BRANCH, detail2$BEGTIME, d...

Hi All, I was wondering if there was a function in R that would output the total run time for various scripts. For now I have the following workaround: begTime <- Sys.time() ... the rest of the R script... runTime <- Sys.time()-begTime Is there another function that I don't know about that would return this information in a more elegant manner? Thanks! [[alternative HTML version deleted]]

...c.SIZE 'SIZEctrl' FROM edt e, ctq c WHERE e.SYMBOL = c.SYMBOL AND julianday(e.DATE) - julianday(c.DATE) BETWEEN 15 AND 75 AND strftime('%H:%M:%S',c.TIME) BETWEEN strftime('%H:%M:%S',e.BEGTIME) AND strftime('%H:%M:%S',e.ENDTIME)") [[alternative HTML version deleted]]