Re: Error in select

From: Q-IK Q-IK <erich.fromm_at_gmail.com>
Date: Fri, 9 Nov 2012 01:47:38 -0800 (PST)
Message-ID: <73d83045-c220-45b3-8503-50793f2216aa_at_googlegroups.com>

W dniu piątek, 9 listopada 2012 10:23:04 UTC+1 użytkownik Noons napisał:
> 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...

When i dont using quotes i have such error:

ORA-00904: "PLANOWANA_DATA": niepoprawny identyfikator 00904. 00000 - "%s: invalid identifier" *Cause:
*Action:
Error at Line: 1 Column: 55 Received on Fri Nov 09 2012 - 10:47:38 CET