8
This is from modules/mylinks/sql/mysql.sql, XOOPS 2.0.9.2:
#
# Table structure for table `mylinks_links`
#
CREATE TABLE mylinks_links (
lid int(11) unsigned NOT NULL auto_increment,
cid int(5) unsigned NOT NULL default '0',
title varchar(100) NOT NULL default '',
url varchar(250) NOT NULL default '',
logourl varchar(60) NOT NULL default '',
submitter int(11) unsigned NOT NULL default '0',
status tinyint(2) NOT NULL default '0',
[color=ff0000]date int(10) NOT NULL default '0',[/color]
hits int(11) unsigned NOT NULL default '0',
rating double(6,4) NOT NULL default '0.0000',
votes int(11) unsigned NOT NULL default '0',
comments int(11) unsigned NOT NULL default '0',
PRIMARY KEY (lid),
KEY cid (cid),
KEY status (status),
KEY title (title(40))
) TYPE=MyISAM;
I don't know why your column is of type datetime. But if the PHP script interprets a value like "2003-12-18 23:30:20" as a Unix timestamp, then I would expect it be displayed like what you're getting.