> I'm running this query: > > INSERT INTO `events`( `domain`, `title`, `body`, `begin`, `end`, > `frequency`, `author` ) VALUES( 000001, 'Test 2', 'Event is not displaying > correct date.', '2003-10-25 24:00:00', '2003-10-01 24:00:00', '0', > 'Rachel' ) > > I get no errors from mysql. (MySQL 3.23.54) on a freebsd system. > > But I do get: > 000003 000001 Test 2 Event is not displaying correct date. 0000-00-00 > 00:00:00 0000-00-00 00:00:00 0 Rachel > > in mysql. > > The dates are all zero. > > Whats going on?
I guess I should have looked at this alittle longer before posting. no such thing as 24th hour.... 23.59 then 0. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
