Skip site navigation (1) Skip section navigation (2)

Re: issue with an assembled date field

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: excalibur(at)accesswave(dot)ca
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: issue with an assembled date field
Date: 2008-02-29 19:33:58
Message-ID: 11003.1204313638@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Chris Bowlby <excalibur(at)accesswave(dot)ca> writes:
> ERROR:  invalid input syntax for type date: "200W-01-01"

> the test data I am using for this example is as follows:

FWIW, I don't see any problem here using that test case.  Have you tried
looking directly at the output of the substring function, ie

select substring(ilch.lot_id::text, 5, 1) FROM my_lot_test ilch;

			regards, tom lane

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2008-02-29 19:46:23
Subject: Re: Upgrade to 8.3.0?
Previous:From: Martin GaintyDate: 2008-02-29 19:18:06
Subject: Re: issue with an assembled date field

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group