Re: First day of month, last day of month

From: "Fernando Hevia" <fhevia(at)ip-tel(dot)com(dot)ar>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: First day of month, last day of month
Date: 2008-04-24 15:10:34
Message-ID: 023b01c8a61d$5855cea0$8f01010a@iptel.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> -----Mensaje original-----
> De: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org] En nombre de Scott Marlowe
>
> Then you can just use date_trunc on the values in the
> database. Plus if you're using timestamp WITHOUT timezone,
> you can index on it.
>

Did not understand this. Are you saying timestamps WITH timezone are NOT
indexable or you mean that you cant build a partial index on a
timestamp-with-time-zone returning function?

Regards,
Fernando.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Scott Marlowe 2008-04-24 15:16:01 Re: First day of month, last day of month
Previous Message Bart Degryse 2008-04-24 15:08:35 Re: First day of month, last day of month