Displaying 5 results from an estimated 5 matches for "startdatetime".
2009 May 06
2
rmysql query help
...the variable in the database and not the value
of the variable.
If I put it outside the quotes, then it complains about the space. Are
there special escape characters or something else Im missing? This date
format in a mysql table is pretty standard
Any ideas?
Thanks,
Aaron
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 >= 'startdatetim...
2006 Aug 08
3
params object nil in controller action
...iteria found in session
logger.debug("if params.nil?=#{params.nil?}")
logger.debug("NOT FOUND :incidentSearch")
if (params[:routeNum].nil? or params[:routeNum].empty?) and
(params[:incidentId].nil? or params[:incidentId].empty?) and
(params[:startDateTime].nil? or params[:startDateTime].empty?) and
(params[:endDateTime].nil? or params[:endDateTime].empty?)
flash[:warning] = "Don''t try stupid things....Enter some search
criteria."
redirect_to :back and return
elsif ((!params[:routeNum].empty? or !pa...
2004 Aug 31
4
Problem with seq.dates in chron
I get faulty output from seq.dates() if I specify a length that is too
long.
For example, I ask for 129 months in the following call to the function,
but it returns
131:
> R.version.string
[1] "R version 1.9.1, 2004-06-21"
> startdatetime <- chron(dates="01/01/1995", times="00:00:00")
> beg.month.datetimes <- seq.dates(from=startdatetime, by="months",
length=129)
> beg.month.datetimes
[1] 01/01/95 02/01/95 03/01/95 04/01/95 05/01/95 06/01/95 07/01/95
08/01/95
[9] 09/01/95 10/01/95 11/01/...
2008 Sep 03
1
ggplot2: line plot with gaps in time axis
...irection
1 2008-08-25 05:00:00 5.862601 Inbound
2 2008-08-25 05:05:00 10.025328 Inbound
3 2008-08-25 05:10:00 5.794900 Inbound
4 2008-08-25 05:15:00 9.862726 Inbound
5 2008-08-25 05:20:00 4.150328 Inbound
6 2008-08-25 05:25:00 5.559362 Inbound
[...]
# startDateTime and stopDateTime is user entered
Start <- as.numeric(as.POSIXct(startDateTime))
End <- as.numeric(as.POSIXct(stopDateTime))
Period<-as.numeric(seq.POSIXt(as.POSIXct(Start,origin="1970-1-1"),
as.POSIXct(End,origin="1970-1-1"), by="DSTday"))
Labels<-as.Date(s...
2005 Jun 01
2
problem with chron scales in lattice
...ow, but instead
only a few of them appear, and in the wrong spots, as if the coordinate
system has changed after finishing with the panel function.
library(chron)
library(lattice)
# vertical grid lines at start of each year
startdate <- "1/1/1992"
enddate <- "1/1/2005"
startdatetime <- chron(dates=startdate, times="00:00:00")
enddatetime <- chron(dates=enddate, times="00:00:00")
x.lines <- as.chron(seq.dates(startdate, enddate, by="years"))
x.limits <- c(as.chron(startdate), as.chron(enddate))
# year labels on x axis (centered between...