Job expiry based on start date/time of job, or completion date/time of job?

I'm pretty sure I've math'd my maths and SQL'd my SQLs correctly.  I wanted
to be sure that job retention was based on the date/time the job
completed rather than when it started.

I did this (PostgreSQL DB if that matters):
SELECT JobId, Name, JobTDate, StartTime, EndTime,
    TIMESTAMP WITH TIMEZONE 'epoch' + JobTDate * interval '1 second' as
JobExpires
  FROM Job LIMIT 40;

Did I understand the assignment and materials correctly?  I think so, I
just want to be sure.

Thanks,
-John

-- 
-- 
- Adaptability -- Analytical --- Ideation ---- Input ----- Belief -
-------------------------------------------------------------------
         John M. Lockard |  U of Michigan - School of Information
          Unix Sys Admin |      Suite 205 | 309 Maynard Street
      [email protected] |        Ann Arbor, MI  48104-2211
 www.umich.edu/~jlockard <http://www.umich.edu/%7Ejlockard> |
734-615-8776 | 734-763-9677 FAX
-------------------------------------------------------------------
- The University of Michigan will never ask you for your password -

_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users