Author: Dan
Date: 17-11-04 00:57
Dan wrote:
> I think I may leave the server in PST but change the database
> field to be without a timezone. The input data is already in
> UTC, so all I need to do is strip away the timezone and we're
> done.
I found an easy way to convert timezones in the database:
freshports.org=# select commit_date, commit_date at time zone 'UTC' from commit_log order by id desc limit 5 offset 90;
commit_date | timezone
------------------------+---------------------
2004-11-15 23:14:28-05 | 2004-11-16 04:14:28
2004-11-15 23:14:25-05 | 2004-11-16 04:14:25
2004-11-15 22:58:29-05 | 2004-11-16 03:58:29
2004-11-15 19:57:44-05 | 2004-11-16 00:57:44
2004-11-15 19:48:27-05 | 2004-11-16 00:48:27
(5 rows)
|
|
If you buy from Amazon USA, please support us by using this link.
