Chris Bowlby <excalibur(at)accesswave(dot)ca> writes:
> I am converting an encoded field (lot_id) into a date field, the 5
> character of every lot_id is always the year and as such I need to
> extract the year using the following function:
> substring(ilch.lot_id::text, 5, 1)
Well, I'd say that the failure proves that some of your data does
*not* have the year in the fifth character.
> ERROR: invalid input syntax for type date: "01/01/0W"
Time for some data sanitizing?
regards, tom lane
In response to
pgsql-general by date
|Next:||From: brian||Date: 2008-02-29 18:53:18|
|Subject: Re: issue with an assembled date field|
|Previous:||From: abracadabuda||Date: 2008-02-29 18:40:18|
|Subject: Re: pgsql structure export to XML|