I need to edit join dates and I was wondering how to do this in SQL ?
I can edit the values in OW_BASE_USER -> JOINSTAMP, but it does not look like a date to me (for example: 1606759854).
Alternatively; is there a plug in that allows me to do this?
Thanks
LeaderThe registration date is stored there, but it is in unix format.
This format is defined as the number of seconds that have elapsed since midnight UTC on January 1, 1970, not counting leap seconds.
You can convert a date from or to this format with free online tools like this one, although there are many more:
https://www.unixtimestamp.com/
There is no plugin that allows you to edit this, you will have to do it manually from the database.
