How to edit member joined date in database?

[TAMAN]

Hello 

i want to change the joined date to another date for some members in my forum, if you can help i would be much appreciated because it is important and i must do it

 

[Daniel F]

You'll need to edit this direct in the core_members database table. The date is stored as timestamp in the joined column.

[TAMAN]

Thank you ^^ 

 

[Julian Jenkins]

Just looking a this too @Daniel F, @TAMAN... can you explain the timestamp please? For example, it shows my join date as April 18 on the site, while my core_members timestamp is 1461004027.

Thanks

[Daniel F]

http://www.epochconverter.com/

[TAMAN]

Yep i also used the same site to convert a date, easy 

[Daniel F]

For lazy mac + alfred people, i can recommand https://github.com/mwaterfall/alfred-datetime-format-converter