You are viewing a single comment's thread from:

RE: Voting analysis: Is @curie still the best community support account?

in #utopian-io6 years ago

Nice stats and very detailed post as usual.

However, there are several errors in the information you provide:

Data is normally 1/2 hours delayed from live

Data from SteemSQL are usually few seconds away from the blockchain. Under heavy load, it can increase to minutes, but rarely more than 5 minutes

The SQL queries to extract the data

In all your queries, you use the GETDATE() function, but you have to use the GETUTCDATE(). because all datetime values in the blockchain are UTC based!

Therefore, except if the computer you use sits in an area which timezone match UTC, you should consider the information you provided as erroneous.

Sort:  

Thanks @arcange!

I wasn't aware of how close to live SteemSQL is, that's great!

Whilst I was originally UTC, I'm now UTC +4 and so I will use this function in future.

Thank you very much for this information!