On May 26, 2011, at 10:04 AM, Mikkel Grum wrote:
> Thanks Marc,
>
> I had just come up with another, slightly more convoluted solution. Add as.is
> = TRUE to the query and then get the timetoken with
> timetoken <- df$timestamp[df$timestamp == max(as.POSIX(df$timestamp))]
>
> While it looks li
uot;
> d[d == max(as.POSIXct(d))]
[1] "2011-05-25 22:15:11.027118000"
> max(as.POSIXct(d))
[1] "2011-05-25 22:15:11 COT"
--- On Thu, 5/26/11, Marc Schwartz wrote:
> From: Marc Schwartz
> Subject: Re: [R] Time and db precision
> To: "Mikkel Grum&quo
On May 25, 2011, at 6:25 PM, Mikkel Grum wrote:
> I have a loop that regularly checks for new data to analyse in my database.
> In order to facilitate this, the database table has a timestamp column with
> the time that the data was inserted into the database. Something like this:
>
> while (.
I have a loop that regularly checks for new data to analyse in my database. In
order to facilitate this, the database table has a timestamp column with the
time that the data was inserted into the database. Something like this:
while () {
load(timetoken.Rdata)
df <- sqlQuery(con, pas
4 matches
Mail list logo
