| From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
|---|---|
| To: | "Edwin Quijada" <listas_quijada(at)hotmail(dot)com> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Extraer hora |
| Date: | 2004-07-07 22:34:07 |
| Message-ID: | 200407071934.07808.martin@bugs.unl.edu.ar |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
El Mié 07 Jul 2004 18:31, Edwin Quijada escribió:
> Como puedo obtener solo la hora de current_time?
> No existe algo como
> select extract(hour, current_time); ::??
siprebi=> select extract(hour from current_time);
date_part
-----------
19
(1 fila)
--
19:30:01 up 2 days, 11:07, 2 users, load average: 0.64, 0.44, 0.39
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Italo Osorio | 2004-07-07 23:31:09 | Me preocupan los que se van. |
| Previous Message | Patricio Muñoz | 2004-07-07 22:25:43 | Re: Extraer hora |