That’s a common request and the long-standing solution is to use your History Stats sensor with the Utility Meter integration.
That’s what I have used to record heating (and cooling) times for daily/weekly/monthly/yearly for three years now. No need to change Recorder’s purge duration or tinker with SQL.
Be advised that the Utility Meter integration will only show data going forward from the moment you implement it.