If the date is on the first of the month the month will also be changed. I am really sure it is the timezone. Don't forget that every user can have his own timezone in joomla.
Please send a sql-dump with the structure of your table and 2 or 3 examples to service@feenders.de
Code:
DROP TABLE IF EXISTS `krcw_joodb_sample`;
CREATE TABLE IF NOT EXISTS `krcw_joodb_sample` (
`myid` int(1) NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL,
...
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`state` tinyint(1) NOT NULL DEFAULT '0',
`image` longblob,
PRIMARY KEY (`myid`),
KEY `title` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
INSERT INTO `krcw_joodb_sample` (`myid`, `title`, `value`, `usefull`, `picture`, `short_description`, `description`, `wikipedia`, `category`, `date`, `state`, `image`) VALUES
(3, 'Basketball', '9,45', 'Yes', 'basketball.jpg', 'A Baskeball sport utility.', 'Basketball is a team sport ...', 'http://en.wikipedia.org/wiki/Basketball', 'Sport', '2009-10-27 15:36:39', 1, NULL),
(12, 'Paprika', '1,9', 'Yes', 'paprica.jpg', 'I wonder why people .....', 'http://en.wikipedia.org/wiki/Paprika', 'Food', '2009-10-15 16:15:46', 1, NULL),
(13, 'Football', '14', 'Yes', 'football.jpg', 'In America ....', 'Football is the name ....', 'http://en.wikipedia.org/wiki/Football', 'Sport', '2009-10-27 17:27:31', 1, NULL);
