Estas tratando de realizar esta operacion desde un stored procedure? Si
es asi, investiga como se hace para concatenar variables tipo
character. Creo que simplemente poner tu variable en un comando no es
suficiente.
Saludos,
Edward Ross
On 04/11/2012 10:42 AM, yeison garcia wrote
Tom Lane wrote:
Edward Ross writes:
Here is a sandbox example of what I mean.
CREATE TABLE test_0
(
string_value varchar(2047),
timestamp_value timestamp with time zone
);
insert into test_0
(string_value)
values
('2010-03-12 17:06:21-0800'),
(&
e to specify a time zone. But
apprently to_timestamp has no way of inputting time zones. Does anyone
know of another way?
Thanks,
Edward Ross
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
