Would someone please tell me how I can modify the user registration date for users in phpMyAdmin (unless there's a better place)? I'll be adding users and this field will need to be modified as they were members long before being added to the XOOPS database for this organization. I do not understand the date timestamp format unixtime (int(10)) when I examine the record. I just want to know how modify "Member since" date to 12/01/1989 (doesn't have to be that format - can be Dec. 1, 1989) or similar. Would someone help?

Thanks.

If your version of phpMyAdmin has UNIX_TIMESTAMP in the Function dropdown on the edit page, select that function and enter the value "1989-12-01 12:00:00".

You could also use the query (XOOPS 2.2.x):

UPDATE xxxx_user_profile SET user_regdate = UNIX_TIMESTAMP("1989-12-01 12:00:00") WHERE profileid = yyyy

where xxxx is your table prefix and yyyy is the ID of the user you're changing.

I recommend backing up the database first.

Worked like a charm. Thank you.

Quote: