Latest entry
A brief Python / SQLite example
This evening I had a situation where I had an SQLite database that had columns holding dates with different or no time zone. Running a query like so:
SELECT created,modified FROM objects;
… returned this:
… 2008-01-21 20:29:10-08:00 | 2008-01-22 10:58:48-08:00 2008-01-22 12:57:43-08:00 | 2008-01-22 13:20:48-08:00 2008-01-29 16:39:17 | 2008-06-12 06:56:33-07:00 2008-01-30 20:27:32-08:00 | 2008-01-30 20:25:49-08:00 2008-02-02 20:58:34 | 2008-06-09 08:46:41-07:00 2008-02-06 01:53:22-08:00 | 2008-02-06 01:51:37-08:00 2008-03-11 12:28:07 | 2008-06-09 08:27:37-07:00 2008-03-19 10:25:58-07:00 | 2008-04-02 03:56:13-07:00 2008-04-15 10:56:43-07:00 | 2008-05-05 17:06:28-07:00 2008-04-23 10 ...