Index: trunk/MagicSoft/Mars/Changelog
===================================================================
--- trunk/MagicSoft/Mars/Changelog	(revision 8167)
+++ trunk/MagicSoft/Mars/Changelog	(revision 8168)
@@ -18,4 +18,11 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2006/10/27 Thomas Bretz
+
+   * datacenter/macros/buildsequenceentries.C:
+     - included a fix for 0000-00-00 times in the run-database
+
+
 
  2006/10/26 Daniela Dorner
Index: trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C	(revision 8167)
+++ trunk/MagicSoft/Mars/datacenter/macros/buildsequenceentries.C	(revision 8168)
@@ -294,5 +294,6 @@
         query += " MIN(fZenithDistance), MAX(fZenithDistance), ";
         query += " MIN(fAzimuth), MAX(fAzimuth), ";
-        query += " MIN(fRunStart), MAX(fRunStop), ";
+        query += " MIN(if(fRunStart=0,NULL,fRunStart), ";
+        query += " MAX(if(fRunStop=0,NULL,fRunStop), ";
         query += " ELT(MAX(FIELD(fLightConditionsKEY, 1, 2, 7, 5, 8)), 1, 2, 7, 5, 8) ";
         query += " FROM RunData WHERE ";