You are viewing a single comment's thread from:
RE: Voting analysis: Is @curie still the best community support account?
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.
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!