XF 2.1 Change join date

[Monkeytime]

When we imported this forum, the forum's oldest member lost his join date when we merged his two usernames in the wrong direction. I'd like to honor his position by having his join date reflect the original launch 18 years ago.

It seems this questions comes up every now and then, but no obvious SQL answer. Can't find an addon either for 2.1.

So, I figure I'll just change it in sql, but this is what I find.

How do I transpose desired date into the date convention used by xenforo in this pic?
(this is not the user in question, just a random).

 

[Paul B]

Unix Time Stamp - Epoch Converter

Epoch and unix timestamp converter for developers. Date and time function syntax reference for various programming languages.

www.unixtimestamp.com

 

[Mr Lucky]

That's a good tool. I just did it by trial and error.

 

[Monkeytime]

I went to change the date with Brogan's reference tool, and it was already where it was supposed to be. I know I merged old to new because old forum is still live for verification. So, I misinterpreted what I saw after the merge, or there was a cron job cleanup that possibly corrected the join date to the older of the two after the fact?

 

[Paul B]

There is no cron job related to account merges.

The database for the user record is updated at the time the merge is done.

The oldest date is used.