List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 29 2004 3:03am
Subject:Re: Using epoch date instead of calendar date
View as plain text  
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
	dnelson@stripped
Thread
Using epoch date instead of calendar dateEric Wagar29 Nov
  • Re: Using epoch date instead of calendar dateChris29 Nov
    • Re: Using epoch date instead of calendar dateEric Wagar29 Nov
      • Re: Using epoch date instead of calendar dateChris29 Nov
        • about berkeley db黄 俊源29 Nov
          • Re: about berkeley dbDan Nelson29 Nov
  • Re: Using epoch date instead of calendar dateDan Nelson29 Nov
    • Re: Using epoch date instead of calendar dateEric Wagar29 Nov