mySQL question - GoFuckYourself.com - Adult Webmaster Forum

X

Caspah

Confirmed User

Join Date: Oct 2003

Posts: 251
Share

Post
#1

mySQL question

11-03-2003, 05:26 PM

i have a question for anyone that knows sql cuz im a noob...

SQL> INSERT INTO IS_QUALIFIED
2 VALUES (1234, 'ISM 1234','1988-09-09');
VALUES (1234, 'ISM 1234','1988-09-09')
*
ERROR at line 2:
ORA-01861: literal does not match format string

How can i fix this error with inserting the date as a value?
I appreciate any help anyone can give.

FreeTicketCash - Everyone likes to signup for a free ticket, wide variety of free e-mail sites!
DatingGold - 1$ per email dating site, also per signup.
Tags: None
icedemon

Confirmed User

Join Date: Jun 2003

Posts: 1022
Share

Post
#2

11-03-2003, 05:40 PM

What is that "2" on the 2nd line. It should be something like this

INSERT INTO IS_QUALIFIED VALUES (1234, 'ISM 1234','1988-09-09');

I hope your not using spaces in your table names.

Clips4Sale.com
Comment
Caspah

Confirmed User

Join Date: Oct 2003

Posts: 251
Share

Post
#3

11-03-2003, 06:02 PM

If you mean by spaces in my tables as the IS_QUALIFIED...spaces where the underscore is? No, I have underscores. That 2 was there because i pressed enter and did it on the second line. How would I format the date so I can just use a month and year. Every time I try it like that it says the wrong format. Thanks for whatever info someone can let me know.

FreeTicketCash - Everyone likes to signup for a free ticket, wide variety of free e-mail sites!
DatingGold - 1$ per email dating site, also per signup.
Comment
NetRodent

Confirmed User

Join Date: Jan 2002

Posts: 3985
Share

Post
#4

11-03-2003, 06:09 PM

I'm guessing your table is set to the "date" column expects a "date". If you want to do just years and months either change it to a "char" column. You may be better of keeping the date format but just ignoring the day (always use 01).

"Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
--H.L. Mencken
Comment
Lane

Will code for food...

Join Date: Apr 2001

Posts: 8496
Share

Post
#5

11-03-2003, 06:11 PM

switch to mysql
what u're using is Oracle ?
Comment
TEK9

Registered User

Join Date: Nov 2003

Posts: 3
Share

Post
#6

11-03-2003, 06:11 PM

Originally posted by Caspah
i have a question for anyone that knows sql cuz im a noob...

SQL> INSERT INTO IS_QUALIFIED
2 VALUES (1234, 'ISM 1234','1988-09-09');
VALUES (1234, 'ISM 1234','1988-09-09')
*
ERROR at line 2:
ORA-01861: literal does not match format string

How can i fix this error with inserting the date as a value?
I appreciate any help anyone can give.

the problem is you haven't told it what columns to put the values in. It should look like this:

INSERT INTO IS_QUALIFIED (name, of, each, column)
VALUES (1234, 'ISM 1234','1988-09-09');

the names of each column should come in the first set of parentheses (don't forget the commas), and then the proper values in the SAME ORDER come in the second set of parentheses.
Comment
sweet7

Confirmed User

Join Date: May 2003

Posts: 1792
Share

Post
#7

11-03-2003, 06:15 PM

Tek 9 has a point but it doesn't need to be specified unless you're re-arranging the order of the fields or leaving some fields out altogether.

Do what netrodent said if you want the date but not necessarily in the mysql format then use regular char types for your fields.

A little reading never hurt anybody

ICQ: 282814268
Comment
Caspah

Confirmed User

Join Date: Oct 2003

Posts: 251
Share

Post
#8

11-03-2003, 06:41 PM

Still getting the same error...

Table command:

CREATE TABLE IS_QUALIFIED
(FACULTY_ID INTEGER NOT NULL,
COURSE_ID VARCHAR2(8) NOT NULL,
DATE_QUALIFIED VARCHAR2(10) NOT NULL,
CONSTRAINT IS_QUALIFIED_PK PRIMARY KEY (FACULTY_ID, COURSE_ID),
CONSTRAINT IS_QUALIFIED_FK FOREIGN KEY (FACULTY_ID) REFERENCES FACULTY (FACULTY_ID),
CONSTRAINT IS_QUALIFIED_FK2 FOREIGN KEY (COURSE_ID) REFERENCES COURSE (COURSE_ID));

Load command:

INSERT INTO IS_QUALIFIED
VALUES (2143, 'ISM 3112', '1988-09-01');
INSERT INTO IS_QUALIFIED
VALUES (2143, 'ISM 3113', '1988-09-01');
INSERT INTO IS_QUALIFIED
VALUES (3487, 'ISM 4212', '1995-09-01');
INSERT INTO IS_QUALIFIED
VALUES (3487, 'ISM 4930', '1996-09-01');
INSERT INTO IS_QUALIFIED
VALUES (4756, 'ISM 3113', '1991-09-01');
INSERT INTO IS_QUALIFIED
VALUES (4756, 'ISM 3112', '1991-09-01');

they are all in the correct order also..

FreeTicketCash - Everyone likes to signup for a free ticket, wide variety of free e-mail sites!
DatingGold - 1$ per email dating site, also per signup.
Comment
TEK9

Registered User

Join Date: Nov 2003

Posts: 3
Share

Post
#9

11-03-2003, 06:50 PM

you're never gonna get anywhere until you tell it what columns to put the values in
Comment
Caspah

Confirmed User

Join Date: Oct 2003

Posts: 251
Share

Post
#10

11-03-2003, 07:09 PM

INSERT INTO IS_QUALIFIED(FACULTY_ID, COURSE_ID, DATE_QUALIFIED)
VALUES (2143, 'ISM 3112', '1988-09-01');

^^^i tried that also and it still didnt work.

FreeTicketCash - Everyone likes to signup for a free ticket, wide variety of free e-mail sites!
DatingGold - 1$ per email dating site, also per signup.
Comment
TEK9

Registered User

Join Date: Nov 2003

Posts: 3
Share

Post
#11

11-03-2003, 07:30 PM

i dunno then. you might want to change the column for the date back into the DATE format, and use the TO_DATE command when you format the value:

TO_DATE('1988-09-01', 'yyyy-Mon-dd')
Comment
Caspah

Confirmed User

Join Date: Oct 2003

Posts: 251
Share

Post
#12

11-03-2003, 07:52 PM

Thanks for the help guys

FreeTicketCash - Everyone likes to signup for a free ticket, wide variety of free e-mail sites!
DatingGold - 1$ per email dating site, also per signup.
Comment

Previous template Next

Working...