Databases
StackOverflow2013
Postsdbo
POHow to get timestamp of tick precision in .NET / C#?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to get timestamp of tick precision in .NET / C#?
    primarykey
    data
    text
    <p>Up until now I used <code>DateTime.Now</code> for getting timestamps, but I noticed that if you print <code>DateTime.Now</code> in a loop you will see that it increments in descrete jumps of approx. 15 ms. But for certain scenarios in my application I need to get the most accurate timestamp possible, preferably with tick (=100 ns) precision. Any ideas? </p> <p><strong>Update:</strong></p> <p>Apparently, <code>StopWatch</code> / <code>QueryPerformanceCounter</code> is the way to go, but it can only be used to measure time, so I was thinking about calling <code>DateTime.Now</code> when the application starts up and then just have <code>StopWatch</code> run and then just add the elapsed time from <code>StopWatch</code> to the initial value returned from <code>DateTime.Now</code>. At least that should give me accurate relative timestamps, right? What do you think about that (hack)? </p> <p><strong>NOTE:</strong></p> <p><code>StopWatch.ElapsedTicks</code> is different from <code>StopWatch.Elapsed.Ticks</code>! I used the former assuming 1 tick = 100 ns, but in this case 1 tick = 1 / <code>StopWatch.Frequency</code>. So to get ticks equivalent to DateTime use <code>StopWatch.Elapsed.Ticks</code>. I just learned this the hard way.</p> <p><strong>NOTE 2:</strong></p> <p>Using the StopWatch approach, I noticed it gets out of sync with the real time. After about 10 hours, it was ahead by 5 seconds. So I guess one would have to resync it every X or so where X could be 1 hour, 30 min, 15 min, etc. I am not sure what the optimal timespan for resyncing would be since every resync will change the offset which can be up to 20 ms. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPeter Mortensen
    1. This table or related slice is empty.
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTLinked
    3. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to get timestamp of tick precision in .NET / C#?
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POHow to get timestamp of tick precision in .NET / C#?
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to get timestamp of tick precision in .NET / C#?
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSurely the date/time set on the server isn't guaranteed to be accurate to 100ns, so I'm not sure what use having an "accurate" timestamp would be (as it's accuracy would only be that of the server)?
      singulars
      1. POHow to get timestamp of tick precision in .NET / C#?
      1. USDan Diplo
    2. COI need to time real-time financial data where accuracy is very important.
      singulars
      1. POHow to get timestamp of tick precision in .NET / C#?
      1. This table or related slice is empty.
    3. COObviously, I like your hack. :) But why does financial data need to be accurate to 100ns? I can understand this if you're timestamping data written to a database, and you need to discriminate between rows that would otherwise have exactly the same timestamp values.
      singulars
      1. POHow to get timestamp of tick precision in .NET / C#?
      1. USMusiGenesis
 

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