| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Miguel Bernilla Sánchez <mbernilla(at)sedapal(dot)com(dot)pe> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: timeofday() :: timestamp |
| Date: | 2007-07-05 19:23:30 |
| Message-ID: | 20070705192330.GC21455@alvh.no-ip.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Miguel Bernilla Sánchez escribió:
> En FreeBSD --> version 8.2.3
>
> sisintegral=# select timeofday();
>
> -------------------------------------
> timeofday
> -------------------------------------
> Mon Sep 04 07:06:51.734909 2006 ECT
> (1 row)
>
> Pero,no puedo hacer *timeofday() :: timestamp*
>
> sisintegral=# select timeofday()::timestamp;
> ERROR: invalid input syntax for type timestamp: "Mon Sep 04 07:09:56.101818 2006 ECT"
> ERROR: invalid input syntax for type timestamp: "Mon Sep 04 07:09:56.101818 2006 ECT"
El problema, me parece, es que ECT no es un huso horario reconocido.
¿Que es? Estas seguro que existe?
--
Alvaro Herrera http://www.PlanetPostgreSQL.org/
"La victoria es para quien se atreve a estar solo"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Miguel Bernilla Sánchez | 2007-07-05 19:29:48 | Re[2]: timeofday() :: timestamp |
| Previous Message | Miguel Bernilla Sánchez | 2007-07-05 19:18:41 | Re[2]: timeofday() :: timestamp |