Databases
StackOverflow2013
Postsdbo
PO.NET AddDays issue
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO.NET AddDays issue
    primarykey
    data
    text
    <p>The next 2 lines adds the same amount to the same date, and the results date part is the same, but somehow the there's difference in the time part!</p> <pre><code>(new DateTime(2000,1,3,18,0,0)).AddDays(4535); (new DateTime(2000,1,3,18,0,0)).AddMonths(149); </code></pre> <p>you'll get a difference of 15 secs, and with both are at least roundable to days, I don't know why this happend, but it happens only with AddDays, but not AddMonths (even with thousands of months added)</p> <hr> <p><strong>Edit 1</strong></p> <p>So I've tried to make a sample project, but no luck. If I run my main project, and put the sample lines into the watches, than I get 2 separate values, if I make a fresh start, the problem is not there. The project is 3.5, c#, vs2010, win7hp x64 (proj: x86). I'm trying to reproduce it also in a fresh small project, I'll be writing back if I have it.</p> <p>These are my results in the main project (copeid from watches!):</p> <pre><code>(new DateTime(2000, 1, 3, 18, 0, 0)).AddDays(4535).Ticks 634743432153600000 long (new DateTime(2000, 1, 3, 18, 0, 0)).AddMonths(149).Ticks 634743432000000000 long </code></pre> <hr> <p><strong>Edit 2</strong></p> <p>I've managed to narrow it down even more. We have a self-made component, panel base, we draw on it with directx. If I make that visible=false, than visible=true, than the error comes, before the visible=true (or show()), the calculation is correct. What in the world can be there, that the result gets something else of a formula where no variable is used. Culture is not affected in the component..</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USkapa
    1. USuser1269009
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. PO.NET AddDays issue
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO.NET AddDays issue
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO.NET AddDays issue
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCould be an issue due to datatype, since AddDays takes a double. Seems like the difference should be a lot less than 15 seconds, though. Check out http://en.wikipedia.org/wiki/Double_precision to see how it just approximates values.
      singulars
      1. PO.NET AddDays issue
      1. USMike Guthrie
    2. COHave you tried reversing the order of the method calls to see if you get the same result? It probably won't make a difference but I'm curious.
      singulars
      1. PO.NET AddDays issue
      1. USBrian Driscoll
    3. COI have not been able to reproduce this (on C# 4 compiler). What is your environment?
      singulars
      1. PO.NET AddDays issue
      1. USSWeko
 

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