| From: | ruben avila galindo <ruben2218(at)gmail(dot)com> |
|---|---|
| To: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
| Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
| Subject: | Re: Execute SQL en Function |
| Date: | 2011-11-29 17:33:23 |
| Message-ID: | CAKavrFpo_-66ojZxYrD+LsshbQtJ+StE7BW0N3FXYnHY=G=a=g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
asi le mando a la funcion
select * from sch_rpt.fun_ventas(1,1,'2011-11-24
07:00:00',null,null,null,101)
ERROR: syntax error at or near "07"
LINE 10: ..._maq_casino = 101and fecha >=2011-11-24 07:00:00-0...
^
2011/11/29 Jaime Casanova <jaime(at)2ndquadrant(dot)com>
> On Tue, Nov 29, 2011 at 12:20 PM, ruben avila galindo
> <ruben2218(at)gmail(dot)com> wrote:
> > SSQL = SSQL || 'and fecha >='|| to_timestamp(arg_fecha,'YYYY-MM-DD
> HH:MM:SS')
>
> esyo deberia decir:
> to_timestamp(arg_fecha,'YYYY-MM-DD HH:MI:SS')
>
> --
> Jaime Casanova www.2ndQuadrant.com
> Professional PostgreSQL: Soporte 24x7 y capacitación
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rodrigo Gonzalez | 2011-11-29 17:58:03 | Re: Execute SQL en Function |
| Previous Message | Jaime Casanova | 2011-11-29 17:25:44 | Re: Execute SQL en Function |