Hi, Peter! * Peter Valdemar M?rch <[EMAIL PROTECTED]> [04/12/28 17:33]: > Hi there, > > A bug was fixed in 4.0.23: > >* Fixed bug which caused FROM_UNIXTIME() function to return wrong > > result if the argument was too big. > >http://bugs.mysql.com/6439 > > However, it looks like it has side effects: > select FROM_UNIXTIME(0) returns "1970-01-01 01:00:00" in 4.0.22 but NULL > in 4.0.23... (European localtime) > > Needless to say, this confuses application logic (especially if the type > is DATETIME NOT NULL). > > Is this a bug? Should I file a bug at http://bugs.mysql.com/ ?
Yes this is a bug. It was already reported as #7515 "from_unixtime(0) now returns NULL instead of the epoch". So no need to report it once more. It will be fixed ASAP. Anyway, thank you for raising this question once again! -- Dmitri Lenev, Software Developer MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
