Monthly archives: November 2007

 

 

192

MySQL dates

PhpBB stores dates in INT fields in Unix time format, meaning the integer value equals to the number of seconds since 1/1/1970. To view the date in standard format, use FROM_UNIXTIME(field) function. select user_id, username, FROM_UNIXTIME(user_regdate) as d from phpbb_users To select a time interval, we need to use FROM_UNIXTIME( ) function with a DATE_ADD() [...]