In the last episode (Nov 28), Eric Wagar said: > 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?
This is in the manual. See FROM_UNIXTIME and UNIX_TIMESTAMP: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
