2009/12/6 José María Terry Jiménez :
>
> Thank you very much. This worked, also worked with ' instead $outer$ BUT
> escaping the ' in minute with two of them ' 'minute' '.
>
> What does $outer$ or when i must use it?
It's a type of quoting... Take a look here:
http://www.postgresql.org/docs/8.3
Alban Hertroys escribió:
On 6 Dec 2009, at 4:13, Scott Marlowe wrote:
On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
wrote:
Hello all,
I'm trying to do a crosstab from data that row names are times.
These times are timestamps and i want to use they truncating to minute
Scott Marlowe escribió:
On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
wrote:
Hello all,
I'm trying to do a crosstab from data that row names are times.
These times are timestamps and i want to use they truncating to minutes
this works for me:
select distinct date_trunc('mi
Richard Broersma escribió:
On Sat, Dec 5, 2009 at 11:11 AM, Jose Maria Terry Jimenez
wrote:
select distinct date_trunc('minute',"timestamp") as "timestamp" from
historico order by "timestamp";
Notice the example from the documentation:
http://www.postgresql.org/docs/8.4/interactive/f
On 6 Dec 2009, at 4:13, Scott Marlowe wrote:
> On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
> wrote:
>> Hello all,
>>
>> I'm trying to do a crosstab from data that row names are times.
>>
>> These times are timestamps and i want to use they truncating to minutes
>> this works f
On Sat, Dec 5, 2009 at 12:11 PM, Jose Maria Terry Jimenez
wrote:
> Hello all,
>
> I'm trying to do a crosstab from data that row names are times.
>
> These times are timestamps and i want to use they truncating to minutes
> this works for me:
>
> select distinct date_trunc('minute',"timestamp"
On Sat, Dec 5, 2009 at 11:11 AM, Jose Maria Terry Jimenez
wrote:
> select distinct date_trunc('minute',"timestamp") as "timestamp" from
> historico order by "timestamp";
Notice the example from the documentation:
http://www.postgresql.org/docs/8.4/interactive/functions-datetime.html#FUNCTIONS-DA
