pgAdmin converts timestamps to the format:
'2001-12-04 00:00:00'
A quick test of this format:
helpdesk=# create table ts(ts1 timestamp);
CREATE
helpdesk=# insert into ts values('2001-12-04 00:00:00');
INSERT 408834 1
A test of the format in your query:
helpdesk=# insert into ts values('2001-1
It doesn't know this is a timestamp so I guess it sees 00 and tries to read
as a number. to get it to work try putting it in appostraphes. This should
make it of type text. If this isn;t automatically cast then us the following
(assuming its a timestamp):
CAST ('2001-12-04 00:00:00.0' AS timestam
