That's what I get for thinking... I just tried that, ie: "create table test (dt datetime NOT NULL default '0000-00-00 00:00:00');"
on mysql 3,4 and 5. No problems. At least not with 'C' or 'en_US' locales set. Sorry for wasting the bandwidth... On Aug 21, 2007, at 10:26 AM, [EMAIL PROTECTED] wrote: > Hi, >> I know I'm a newb here, and I'm not a Mysql expert, but it looks to >> me like '0000-00-00 00:00:00" is clearly outside the allowed range, >> if that range is published as '1000-01-01 00:00:00' - '9999-12-31 >> 23:59:59' > > just what i was thinking - but its worked until now ..hang on... > > nope. even 2.0 CVS has all 0's (though as you say...maybe it > shouldnt) > though 2.0 now doesnt CapiTaliZe the variables. > > what version of mysql are you running? 3.x or 4.x might be very fussy? > > alan > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/ > users.html > > !DSPAM:1462,46cb20bc202631603212334! > -- Don - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
