Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-14885

Use either nanoseconds or MJD in PPDB CcdVisit table

    Details

    • Templates:
    • Story Points:
      2
    • Epic Link:

      Description

      The prompt product database currently has a column called expMidptMJD which is in units of seconds. These timestamps are constructed via exposure.getId().getVisitId().getDate().nsec() * 1.e-9, which means zero seconds corresponds to the daf_base DateTime nanosecond zeropoint. However, none of this is clear without some digging.

      Since this field has MJD in the name, it would make sense to have MJD as units here. Another option would be to return nanoseconds and change the column name accordingly, since that is the default time unit for our daf_base DateTime objects. Either way, MJD should be a float and nanoseconds should be an int in order to have consistent behavior with DateTime.

        Attachments

          Container Issues

            Activity

              People

              • Assignee:
                cmorrison Chris Morrison
                Reporter:
                mrawls Meredith Rawls
                Reviewers:
                Meredith Rawls
                Watchers:
                John Swinbank, Meredith Rawls
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Summary Panel