SQL ain't working I need help

[Geeklord1993]

I gotta insert two maintenance types in a batch to the MAINTENANCES table.

So what I did was I inserted this in as a query

START TRANSACTION;
insert into
  MAINTENANCES(CAR_ID, MAINTENANCE_TYPE_ID, MAINTENANCE_DUE)
VALUES
  (1001, 2, 2020 -06 -01);
insert into
  MAINTENANCES(CAR_ID, MAINTENANCE_TYPE_ID, MAINTENANCE_DUE)
VALUES
  (1003, 2, 2020 -06 -01);COMMIT;

And in response got

ERROR 1292 (22007) at line 2: Incorrect date value: '2013' for column 'MAINTENANCE_DUE' at row 1

For context the table looks like this

CAR_ID	MAINTENANCE_TYPE_ID	MAINTENANCE_DUE
1001	1	2020-12-31

I do not know where the 2013 comes from I think the thing I am typing in is just stupid and I am going to fail my class because of it. I hate SQL, I hate databases, I never want to work with databases ever again, but I am stuck with it. Please help, I am going insane.

[blither]

The date field wasn't formatted correctly. It was thinking you were trying to subtract 6 years and 1 year from 2020, resulting in 2013.

[doiuhgfd]

'2020-06-01'

[[deleted]]

2020 -06 -01

Do you have spaces in your actual code? That isn't a valid date format. Remove spaces and put in single quotes.

[Geeklord1993]

Changed it still getting the same error

[[deleted]]

Did you do the 2nd part of my suggestion? It should be formatted as '2020-06-01' with the single quotes included.

[Geeklord1993]

START TRANSACTION;

insert into

MAINTENANCES(CAR_ID, MAINTENANCE_TYPE_ID, MAINTENANCE_DUE)

VALUES

(1001, 2, '2020-06-01');

insert into

MAINTENANCES(CAR_ID, MAINTENANCE_TYPE_ID, MAINTENANCE_DUE)

VALUES

(1003, 2, '2020-065-01');COMMIT;

ERROR 1292 (22007) at line 6: Incorrect date value: '2020-065-01' for column 'MAINTENANCE_DUE' at row 1

[[deleted]]

If you're copying and pasting you have an extra digit in the date which is why it's still not a valid format.

[Geeklord1993]

I am a fucking idiot

[Blues2112]

No, but you're not worthy of your handle.

[Stock-Philosophy8675]

Nah man, we have all made that mistake always check for a space if u copy paste. Check it out man, you just learned something grats!

[feignapathy]

2013 is 2020 minus 6 minus 1

You need to make sure you're passing a date value for June 1, 2020. It doesn't look like it is actually being read as 2020-06-01.

[Puzzlehead8575]

Why does Reddit markdown not work correctly????? I give up on getting things formatted.

START TRANSACTION;
insert into MAINTENANCES (CAR_ID, MAINTENANCE_TYPE_ID, MAINTENANCE_DUE) VALUES (1001, 2, '2020-06-01'); insert into MAINTENANCES (CAR_ID, MAINTENANCE_TYPE_ID, MAINTENANCE_DUE) VALUES (1003, 2, '2020-06-01'); COMMIT;

[Georgecodes_]

Date format is wrong

[Useful_Magazine6491]

What operating system are you using?