Changeset 20009

Timestamp:

Oct 8, 2008, 2:45:21 PM (18 years ago)

Author:

Paul Price

Message:

Match to closest two seconds, since the values in the database are
taken from different sources (SHUTOUTC vs MJD-OBS, which can differ
by a little bit).

File:

• trunk/ippconfig/gpc1/format_orig.config (modified) (1 diff)

trunk/ippconfig/gpc1/format_orig.config

@@ -570 +570 @@
         CHIP.TEMP               METADATA
                 # Need to apply correction of 1 month since header still contains bug but database corrected.
-                XY24    STR     SELECT AVG(ccd_temp) FROM rawImfile WHERE dateobs - INTERVAL 1 MONTH = '{FPA.TIME}' AND class_id != 'XY24'
+                XY24    STR     SELECT AVG(ccd_temp) FROM rawImfile WHERE (dateobs - INTERVAL 1 MONTH BETWEEN '{FPA.TIME}' - INTERVAL 2 SECOND AND '{FPA.TIME}' + INTERVAL 2 SECOND) AND class_id != 'XY24'
         END
 END