Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This question has gone on far too long -- especially considering that the question itself links to the answer.</p> <p>This is an output representation problem, and is well-known. Rounding time values has implications. You cannot just round the subsecond values without getting incorrect results in some cases.</p> <p>The solution is here (as linked in the question): <a href="https://stackoverflow.com/questions/7726034/how-r-formats-posixct-with-fractional-seconds">How R formats POSIXct with fractional seconds</a></p> <p>Stealing directly from Aaron's excellent answer:</p> <pre><code>myformat.POSIXct &lt;- function(x, digits=0) { x2 &lt;- round(unclass(x), digits) attributes(x2) &lt;- attributes(x) x &lt;- as.POSIXlt(x2) x$sec &lt;- round(x$sec, digits) format.POSIXlt(x, paste("%Y-%m-%d %H:%M:%OS",digits,sep="")) } x &lt;- as.POSIXct("2012-12-14 15:42:04.577895 EDT") </code></pre> <p>What you are attempting:</p> <pre><code>as.POSIXlt(as.POSIXct(sprintf("%s",(format(x, "%Y-%m-%d %H:%M:%OS6")))))$sec ## [1] 4.577894 </code></pre> <p>Aaron's code:</p> <pre><code>myformat.POSIXct(x, 6) ## [1] "2012-12-14 15:42:04.577895" </code></pre> <p>One might think to use <code>sprintf</code> with a format string of <code>%.06f</code> to format the subsecond value, but this will fail if the value is slightly below an integer:</p> <pre><code>sprintf('%.06f', .9999999) ## [1] "1.000000" </code></pre> <p>Converting to a POSIXlt causes the proper rollover into seconds, minutes, etc., if the subsecond value is rounded up.</p> <p>To show you that this is <strong>not</strong> a data problem:</p> <pre><code>y &lt;- as.numeric(x) y ## [1] 1355521324.5778949261 sprintf('%06f', y - floor(y)) ## [1] "0.577895" </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POPOSIXct micro-seconds inconsistencies in R
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USMatthew Lundberg
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPOSIXct micro-seconds inconsistencies in R
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI linked to what seemed to be an argument, not an answer. I wasn't looking for who's right; just for a solution. So, thanks a lot for re-writing it into the **myformat.POSIXct** function, and providing a good example. Cheers!
      singulars
      1. PO
      1. USzuuz
    2. CO@Mathhew: but still, you added another answer to the question I linked to in the top. So - is the solution you just suggested correct or not?
      singulars
      1. PO
      1. USzuuz
    3. CO@zorbar I did add another answer there instead of here, but that is because the other question is clearer (less localized). And indeed, the behavior that you see is important for me as I work with subsecond time series very often. The solution with `myformat.POSIXct` seems to work fine for dates prior to 2038 (and is much simpler than my answer to the othe question). The real answer is to find the problem in the code. I downloaded the source for investigation.
      singulars
      1. PO
      1. USMatthew Lundberg
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload