Sorry, forgot to told you what I'm trying, I have climate data and want to obtain mean temperature and total precipitation and that sort of things per month and year. Think date_trunc is a good solution, but any other advice would be very welcome.
(I need to read more about time zones, I'm new at using postgresql) Thank you, Daniel 2015-05-21 12:45 GMT-05:00 Paul Jungwirth <p...@illuminatedcomputing.com>: > You really shouldn't use WITHOUT TIME ZONE. >> > > I'd like to know more about this. Can you say why? Are there any articles > you'd recommend? I'm fond of normalizing all times to UTC and only > presenting them in a time zone when I know the current "perspective". I've > written about that approach in a Rails context here: > > http://illuminatedcomputing.com/posts/2014/04/timezones/ > > I find that this helps me to ignore time zones in most parts of my > application and cut down on my timezone-related bugs. > > Thanks! > > Paul > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
