ho Tom, Thanks that gave me the brain burp I needed to click into what was causing the root issue. On Fri, 2008-02-29 at 13:47 -0500, Tom Lane wrote: > Chris Bowlby <excalibur@xxxxxxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
