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
jlock...@umich.edu | 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
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
