Re: Extraer hora

From: Patricio Muñoz <patricio(dot)munoz(at)cmet(dot)net>
To: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>, <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: Extraer hora
Date: 2004-07-07 22:25:43
Message-ID: 003001c46471$57d0cbc0$0500a8c0@ultra.cmet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

----- Original Message -----
From: "Edwin Quijada" <listas_quijada(at)hotmail(dot)com>

>
> Como puedo obtener solo la hora de current_time?
> No existe algo como
> select extract(hour, current_time); ::??

SELECT EXTRACT(HOUR FROM CURRENT_TIMESTAMP);

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Martin Marques 2004-07-07 22:34:07 Re: Extraer hora
Previous Message Martin Marques 2004-07-07 21:59:54 Re: Recomendacion BD rapida