Re: date with month and year

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 <pj(at)illuminatedcomputing(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>