RE: Witness Earnings Weekly Report - 2021-11-22

[masudrana]

How do you get the the first block number in a specific days? lets say what is the first block number in 20 November is UTC timezone or whatever timezone?

Comments

[quochuy]

There is no easy way but you could try:

• fetch current head block and check it’s date
• with a date library calculate the difference in seconds between the target date and the head block date
• divide that number by 3 (we generate a block every 3 seconds)
• take the head block number minus the that needs number
• that’s your block

But since there have been blockchain crashes, if it doesn’t work then keep repeating

[quochuy]

Or you could get an access to HiveSQL