We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Edit join dates | Forum

Topic location: Forum home » Support » General Questions
ES C May 9 '21
Hi all

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?   


Patricia Zorrilla Leader
Patricia Zorrilla May 9 '21

The 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:


There is no plugin that allows you to edit this, you will have to do it manually from the database.

ES C May 9 '21
Oh really! That's very interesting. 

Thanks a lot for you help.