Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Scott MarloweDate: 2008-04-24 15:16:01
Subject: Re: First day of month, last day of month
Previous:From: Bart DegryseDate: 2008-04-24 15:08:35
Subject: Re: First day of month, last day of month

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group