Regression bug in 4.0.23? FROM_UNIXTIME(0) is now NULL, not "1970-01-01 01:00:00"

386) (Debian unstable - present) -- Peter Valdemar Mørch http://www.morch.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.298 / Virus Database: 265.6.5 - Release Date: 12/26/2004 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

Re: help with SQL (join?) query

-- Peter Valdemar Mørch http://www.morch.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Pushing Files from Subversion

the checked out working copies in the universe. The server doesn't know who to pus to. The client has to poll somehow or you need to do something specific for those clients in a post-commit hook script. I'll bet cron + "svn update" is your best friend right around now

Re: timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

ation to int(32) unsigned and handle presentation client-side. I don't think I'll ever use a DATETIME again... Maybe thats just me. Thanks again, Michael. Peter -- Peter Valdemar Mørch http://www.morch.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

dk/~pvm/mysqlTimestamps/timestamps.pl.txt Output of said code (WITH /etc/timezone == "Europe/Copenhagen"!!) http://demo.capmon.dk/~pvm/mysqlTimestamps/output.txt I really hope someone has a good idea what to do now! Peter -- Peter Valdemar Mørch http://www.morch.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

timestamp and DST: impossible to backup database? *AND* bugs in TIMEDIFF, FROM_UNIXTIME, et.al.?

code (WITH /etc/timezone == "Europe/Copenhagen"!!) http://demo.capmon.dk/~pvm/mysqlTimestamps/output.txt I really hope someone has a good idea what to do now! Peter -- Peter Valdemar Mørch http://www.morch.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]