Martin Gainty wrote:
Chris Bowlby wrote:
Hi All,
I am currently running into an issue with a query and would like to get
some assistance if possible.
The PostgreSQL version I am running is 8.0.11 64-Bit, under SuSE Linux
Enterprise Server 9 SP3
I am converting an encoded field (lot_id)
Chris Bowlby <[EMAIL PROTECTED]> 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
sel
Brian is right
change substring(ilch.lot_id::text, 5, 1) and
change '01/01/0'::text ||
to
'01/01/'::text || substring(ilch.lot_id::text,4,2)
M--
- Original Message -
From: "brian" <[EMAIL PROTECTED]>
To:
Sent: Friday, February 29, 2008 1:11 PM
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 <[EMAIL PROTECTED]> writes:
> > I am converting an encoded field (lot_id) into a date field, the 5
> > character of every lot_id
Chris Bowlby wrote:
Hi Colin,
Thanks for your response, if I remove the where clause from my example,
I also am able to execute the query with out issue, as follows:
test=# select tab.dr_prod_date FROM (SELECT ('01/01/0'::text ||
"substring"(ilch.lot_id::text, 5, 1))::date AS dr_prod_date FR
Chris Bowlby <[EMAIL PROTECTED]> 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
Hi Colin,
Thanks for your response, if I remove the where clause from my example,
I also am able to execute the query with out issue, as follows:
test=# select tab.dr_prod_date FROM (SELECT ('01/01/0'::text ||
"substring"(ilch.lot_id::text, 5, 1))::date AS dr_prod_date FROM
my_lot_test ilch) A
Chris Bowlby wrote:
Hi All,
I am currently running into an issue with a query and would like to get
some assistance if possible.
The PostgreSQL version I am running is 8.0.11 64-Bit, under SuSE Linux
Enterprise Server 9 SP3
I am converting an encoded field (lot_id) into a date field, the 5
Chris Bowlby wrote:
test=# select tab.dr_prod_date FROM
test-# (SELECT ('01/01/0'::text || substring(ilch.lot_id::text, 5,
1))::date AS dr_prod_date FROM my_lot_test ilch) AS tab
test-# where tab.dr_prod_date = '2/5/08' limit 1;
ERROR: invalid input syntax for type date: "01/01/0W"
Using arb
Hi All,
I am currently running into an issue with a query and would like to get
some assistance if possible.
The PostgreSQL version I am running is 8.0.11 64-Bit, under SuSE Linux
Enterprise Server 9 SP3
I am converting an encoded field (lot_id) into a date field, the 5
character of every lo
10 matches
Mail list logo