Mike, I checked the data as well. There is no bad data.
On Tue, Aug 24, 2010 at 2:51 PM, Michael Moore <[email protected]>wrote: > You have bad date data in employee.year_month_day. Check the dates in that > table and you will find a bad one. > > Mike > > > On Tue, Aug 24, 2010 at 12:38 PM, swaroop gowda > <[email protected]>wrote: > >> I am trying to get count from one of the table by using date but date >> value is stored as string like 20000603 it is VARCHAR2 field >> >> Begin >> SELECT >> count(*) into dt FROM employee where to_date(year_month_day,'YYYYMMDD') = >> to_date('20000603','YYYYMMDD'); >> End; >> It is throwing an error saying not a valid month when I execute this in >> Toad. >> Same thing if I execute like below It works fine. >> >> select next_day(to_date('20000603','YYYYMMDD')-7,'SUNDAY') into dt from >> employee where rownum = 1; >> >> Please let me know if any one knows why it is giving an error. >> >> -- >> Thanks & Regards >> Swaroop Thailuru Swamy >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en > > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- Thanks & Regards Swaroop Thailuru Swamy -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
