I am attempting to move all my users from my site (currently using XOOPS) to WPMU 2.7.1
I have matched up the proper tables from the db but with my limited sql ability I am stumped about how to convert the unix timestamp from user_regdate in XOOPS to the date format used in WPMU.
I am simply using the sql statement below in the myPHPadmin sql window.
It looks like using FROM_UNIXTIME might be a solution but I am unsure how to use it within the sql statement below.
uid AS 'ID',
uname AS 'login_name',
uname AS 'user_nicename',
pass AS 'user_pass',
url AS 'user_url',
user_regdate AS 'user_registered',
uname AS 'display_name' FROM
mcm_users WHERE 1
Any help would be appreciated.