Testing feature to set instance TTL "from" date

[jobosk]

Use case

I have a very old tests with data that has dates from a specific point in time (let's say mid 2000).
I want to start using TTL settings to ensure my data is never more than 10 old.
We're in 2023, so my old tests will blow up immediately.
I don't want to update my tests to change the dates, specially if I have to do this over the years.
I don't want to set an incredibly large (and fake) TTL to avoid this behaviour.

Describe the solution you'd like

I would love to have a configuration (testing-only) feature when setting up my clickhouse instance, that allows me to set the date used to evaluate the TTL, to a fixed point in time.

[jobosk]

Maybe I'm missing something... Can anyone tell me how's everyone else making their tests when using TTL in their tables?

[den-crane]

My containers run with something like CMD ["date", "-s", "2000-01-01 00:00:00"]
obviously it's problem if SSL is needed

[den-crane]

Also https://stackoverflow.com/questions/29556879/is-it-possible-change-date-in-docker-container