Error in select
From: <erich.fromm_at_gmail.com>
Date: Fri, 9 Nov 2012 01:17:19 -0800 (PST)
Message-ID: <9e2c5ef2-afad-4f75-a156-6bb0f2ef3253_at_googlegroups.com>
Hello,
I have such select:
Date: Fri, 9 Nov 2012 01:17:19 -0800 (PST)
Message-ID: <9e2c5ef2-afad-4f75-a156-6bb0f2ef3253_at_googlegroups.com>
Hello,
I have such select:
SELECT * FROM ifsinfo.q_ial_wysylki_planowane where "Planowana_data" < to_date('09/11/2012','DD/MM/YYYY')
and it's work good, but select:
SELECT * FROM ifsinfo.q_ial_wysylki_planowane where 'Planowana_data' < to_date('09/11/2012','DD/MM/YYYY')
generate error:
01841. 00000 - "(full) year must be between -4713 and +9999, and not be 0"
*Cause: Illegal year entered
*Action: Input year in the specified range
Why?
I must put such select in php - and i have problem with "" and ' '.
Thanks in advance for help.
Q.
Received on Fri Nov 09 2012 - 10:17:19 CET