Re: Error in select

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Fri, 09 Nov 2012 20:23:04 +1100
Message-ID: <k7ii1n$93m$1_at_dont-email.me>

erich.fromm_at_gmail.com wrote,on my timestamp of 9/11/2012 8:17 PM:
> 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.
>

Why are you using quotes around the column name? It's not needed, unless you have a very strange way of defining the tables... Received on Fri Nov 09 2012 - 10:23:04 CET