How to change member since date?

example:
Member Since 1970/1/1
change to date 2007/1/23

hope anybody can help me..

thanks..

Link to a similiar post.

you gotta edit it in the database.
*disclaimer.. uh. back up your database.. before modifying stuff..
the date is in unix time.. so google an Epoch Time Converter and put in the date you want. and convert. ( and leave that window open so you can go back to it later).

then use phpmyadmin or any other tool.
and go to your XOOPS database and look for a table called prefix_users and browse for your id. and then edit it.

edit the 'user_regdate' field by puttin in date that you made with the converter. in to the value for that field. and save..

and that should change your reg date...


- i wonder if there is a module or something for this...

Instead of using that external date converter, you can use MySQL's built-in UNIX_TIMESTAMP function.

When editing the row in phpMyAdmin, for the user_regdate column, select UNIX_TIMESTAMP from the Function menu, and enter the date in the format YYYY-MM-DD HH:MM:SS (in this case, 2007-01-23 12:00:00).

Or use a query such as:



If you use the query, don't forget the WHERE-clause, or you'll change everyone's registration date.

thanks Bandit-X & Dave_L
now i can change my reg date and other user on my XOOPS site..