Re: time - Mailing list pgsql-sql

From Rod Taylor
Subject Re: time
Date
Msg-id 1131646287.819.144.camel@home
Whole thread Raw
In response to time  (Judith Altamirano Figueroa <jaltamirano@correolux.com.mx>)
Responses Re: time
List pgsql-sql
On Thu, 2005-11-10 at 09:03 -0600, Judith Altamirano Figueroa wrote:
> Hello everybody!!!, I'd like to know if there another way to get the
> time from a timestamp type, because in earliest versions I just get
> the time like time(fecha) and now this returns an error, thanks in
> advanced!!!!!!!

rbt=# select cast(now() - date_trunc('day', now()) as time);     time
-----------------13:10:42.495579
(1 row)

-- 



pgsql-sql by date:

Previous
From: Judith Altamirano Figueroa
Date:
Subject: time
Next
From: Michael Fuhr
Date:
Subject: Re: time