Index: trunk/ippToPsps/jython/gpc1db.py
===================================================================
--- trunk/ippToPsps/jython/gpc1db.py	(revision 37750)
+++ trunk/ippToPsps/jython/gpc1db.py	(revision 37753)
@@ -268,5 +268,6 @@
                skycell_id, \
                diffRun.software_ver, \
-               exp_time \
+               exp_time, \
+               (to_days(dateobs)-678941 + time_to_sec(dateobs)/86400.) \
                FROM diffRun join diffInputSkyfile using (diff_id) \
                JOIN warpRun on (warp1=warp_id) \
@@ -276,5 +277,5 @@
                JOIN rawExp using (exp_id) \
                WHERE diff_skyfile_id = %d" % diffSkyfileID
-               
+        #this is a crappy way to get the mjd from the diff but we don't save it anywhere       
         try:
             rs = self.executeQuery(sql)