XOOPS to WP

Hi All

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.

SELECT uid AS ‘ID’, uname AS ‘login_name’, uname AS ‘user_nicename’, pass AS ‘user_pass’, email AS ‘user_email’, url AS ‘user_url’, user_regdate AS ‘user_registered’, uname AS ‘display_name’ FROM mcm_users WHERE 1

Any help would be appreciated.

Thanks Foz