FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

I am looking for an LTO tape library. Do you have one to spare?
Website Feedback
 New Topic  |  Go to Top  |  Go to Topic  |  Search  |  Log In   Previous Message  |  Next Message 
 Re: Timezones
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)

 Reply To This Message  |  Forum List  |  Flat View   Newer Topic  |  Older Topic 

 Topics Author  Date
 Timezones   new
andy 21-05-03 09:32 
 Re: Timezones   new
JunkMale 21-05-03 11:10 
 Re: Timezones   new
andy 22-05-03 06:48 
 Re: Timezones   new
andy 22-05-03 06:52 
 Re: Timezones   new
JunkMale 22-05-03 10:51 
 Re: Timezones   new
AnotherJunkMale 14-11-04 06:15 
 Re: Timezones   new
Dan 14-11-04 13:43 
 Re: Timezones   new
AnotherJunkMale 14-11-04 19:51 
 Re: Timezones   new
Dan 14-11-04 21:01 
 Re: Timezones   new
Dan 16-11-04 23:38 
 Re: Timezones   new
Dan 17-11-04 00:57 
 Re: Timezones   new
Dan 17-11-04 03:26 


 Forum List  |  Need a Login? Register Here 
 User Login
 User Name:
 Password:
 Remember my login:
   
 Forgot Your Password?
Enter your email address or user name below and a new password will be sent to the email address associated with your profile.


Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2014 Dan Langille. All rights reserved.