Advertisement

10.30.2006 at 06:44AM PST, ID: 22042279
[x]
Attachment Details

Not a valid month

Asked by mrong in Oracle Database

Tags: valid, month, date

Hello,

I have the following sql command in Oracle8 DB and got "not a valid month" error.

select *
from tbl1
where tbl1.bill_date='1/1/2006' ;

Any help will be appreciated.

-MStart Free Trial
[+][-]10.30.2006 at 06:50AM PST, ID: 17833952

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.30.2006 at 06:51AM PST, ID: 17833969

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.30.2006 at 06:52AM PST, ID: 17833972

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.30.2006 at 06:56AM PST, ID: 17834010

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.30.2006 at 07:06AM PST, ID: 17834101

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]10.30.2006 at 07:11AM PST, ID: 17834139

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10.30.2006 at 07:17AM PST, ID: 17834200

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle Database
Tags: valid, month, date
Sign Up Now!
Solution Provided By: nav_kum_v
Participating Experts: 4
Solution Grade: A
 
 
[+][-]10.30.2006 at 07:25AM PST, ID: 17834269

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
[+][-]10.30.2006 at 07:29AM PST, ID: 17834307

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32