Looking at the structure of xoops.users shows the users_regdate as int(10), and phpnuke.users is varchar(20).
This means that phpnuke.users would need to be ||UNIX_TIMESTAMP(). And, I see in the MySQL book (2nd ed., pg 828) that UNIX_TIMESTAMP works with date-time or timestamp format of ccyymmdd or yymmdd, which is different than the May 1, 2004, example. Should I assume that I need to run some type of script against that column of data? If so, how do I do it? Thanks Eric > I don't have experience with either of those programs, but I think you > can convert them. > > It looks like phpnuke is keeping the date in a DATE (or maybe a DATETIME > or TIMESTAMP) column and xoops is keeping the date in an INTEGER column > in Unix timestamp format. > > If both of those are true then you can easily convert from one or the > other using the |FROM_UNIXTIME() or ||UNIX_TIMESTAMP() functions. > > >I am testing moving from a phpnuke site to a xoops site. In doing so, I > > am trying to get the user table moved over. > > > >I see in the phpnuke tables (which a similar table exists in xoops) that > > the users have a sign up date. The date in phpnuke is the calendar day, > > May 1, 2004, for example. In xoops, it is seconds since 1-1-1970. > > > >Is there a way to convert all 24K+ users from the day to the second > > format? > > > >And, if not, would it be possible to zero out or empty the records? And, > > what are the ramifications of doing so? (The most important to us is the > > ability to keep username, email, and password.) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
