to_utc_timestamp and from_utc_timestamp do not work correctly over Unix epoch limits

[max-vostrikov]

Describe the unexpected behaviour
to_utc_timestamp and from_utc_timestamp do not work correctly on limits ('1970-01-01 00:00:00'), and around max Date values.

How to reproduce
https://fiddle.clickhouse.com/b0a59bc7-f9ca-41b0-8048-ee023c27f6ab

select to_utc_timestamp(toDateTime('2106-02-07 02:29:17'), 'EST'), from_utc_timestamp(toDateTime('1970-01-01 01:01:01'), 'EST');

Expected behavior
All converts before '1970-01-01 00:00:00' should return '1970-01-01 00:00:00'. All converts after max Date, should return max Date

[bradenburns]

Hi there, I'm a student in the University of Michigan's Software Engineering course and a first-time contributor, I'm wondering if I can take this issue? Thanks!

[aryanpal26]

Hi, could I be assigned this issue?

[max-vostrikov]

@bradenburns @aryanpal26 you can both work on this issue. And if you do this in same time, we could compare PR's and pick the best.
We do not always assign issues to contributors. You can just start working on it and add a link to this in your PR.

[iit2009046]

@max-vostrikov Raised PR:#80498 for this. Please have a look.