Create table project


#1

In the project I just inserted two new entries to the friends table. If you look at my code you will see it specifies their birthday yet when I run a select command it says their birthdays are 1950 and 1960 which is wrong. Also it doesnt say the day of the month and the month. Here is my code:

insert into friends (id, name, birthday)
values (2, ‘Steve Amos’, 1974-06-18);

insert into friends (id, name, birthday)
values (3, ‘Richard Brailsford’, 1980-06-14);

Thanks for your help. Tim


#2

Link to exercise, please. Thanks.


#3

https://www.codecademy.com/courses/learn-sql-manipulation/projects/learn_sql_create_table?course_redirect=learn-sql
thanks


#4

Date values need to be strings…

insert into friends (id, name, birthday)
values (2, 'Steve Amos', '1974-06-18');

insert into friends (id, name, birthday)
values (3, 'Richard Brailsford', '1980-06-14');

#5

Thanks a lot mate. Do you work in IT?


#6

Welcome. No, I’m retired.


#7

What have you worked with? Ever worked with ASP.NET and C#?


#8

No, I was old school… HTML, CSS, JavaScript, PHP. Didn’t learn other languages until after I joined CC. All pretty much a hobby, now.