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

Re: Time Type

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>
Subject: Re: Time Type
Date: 2008-07-29 03:42:00
Message-ID: 322763.57072.qm@web59507.mail.ac4.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
you try to do something like this

select '00:01'::time + interval '10 minutes'


--- On Mon, 7/28/08, Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com> wrote:

> From: Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>
> Subject: [ADMIN] Time Type
> To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
> Date: Monday, July 28, 2008, 6:16 PM
> Hi there,
> 
> I'm trying to do some as following and I couldn't:
> select '00:01:00'::time + '00:10:00'::time
> ERROR:  operator is not unique: time without time zone +
> time without time
> zone at character 127
> HINT:  Could not choose a best candidate operator. You
> might need to add
> explicit type casts.
> 
> Postgres version: 8.3.3
> 
> Anyone knows anything?
> 
> Regards,
> 
> Rafael Domiciano


      


In response to

  • Time Type at 2008-07-28 18:16:12 from Rafael Domiciano

pgsql-admin by date

Next:From: Carol WalterDate: 2008-07-29 15:47:37
Subject: Privileges & roles
Previous:From: Rafael DomicianoDate: 2008-07-28 18:46:50
Subject: Re: Time Type

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