seatgeek/djjob — Issue #17: convert datetime usage to unix timestamps
Author: alexdean
Created: 2012-03-02 02:38:02+00:00
State: open

Curious if you'd accept a patch that does this.

My main reason is that it makes timezones irrelevant. I have some machines where the job server and the database server aren't in the same timezone.

- Since MySQL datetimes don't contain timezone information, correctly scheduling a job to run in the future requires conversion from PHP to MySQL timezone, which isn't simple to do because of all the various config options which can be involved.
- Monitoring the amount of time a job has been on a queue is complex for the same reason.

All the existing functionality could be easily replicated with unix timestamps. Thoughts?