This is the chart needed to be filled out

You will be filling in the blanks in the DateDilemma.xlsx file. The information you will provide for both SQLite and MySQL is a) if inserting a date in a given format is accepted and b) if it was accepted, is it represented properly.

You will need to use DBeaver with MariaDB/MySQL (XAMPP) and SQLite.

Download the attached DateDilemma.xlsx file, where you write your answers.

In both SQLite and MySQL create a table called date_dilemma with two fields as follows:

fmt which contains text up to 25 characters in length

a_date which is a DATE

For each of the rows in DateDilemma.xlsx you will write an insert statement that inserts the formatted date, January 4, 2014, listed under Format as both columns. For example, the first row, '2014-01-04', would be inserted using INSERT INTO date_dilemma VALUES ('2014-01-04', '2014-01-04'); You will do this for both MySQL and SQlite. Fill in the table for each insert.

Be careful with the line that reads DATE '2014-01-04', you'll need to escape those single quotes in the fmt field.

Notice that the last row is labelled "Your format here," (see screenshot below) Choose a date format to try, replace the "Your format here" text with your date format and then fill in the row accordingly.

To test the representation, you will use the following queries:

SQLite: select fmt, a_date, strftime('%m', a_date) as month, strftime('%d', a_date) as day, strftime('%Y', a_date) as year from date_dilemma;

MySQL: select fmt, a_date, month(a_date) as month, day(a_date) as day, year(a_date) as year from date_dilemma;

B3 2 Format 3 2014-01-04 4 '20140104' 5 201414 6 2014-1-4 7 01/04/2014 8 DATE 2014-01-04 9 1 JAN 2014 10 Your format here 13 14 MySQL SQLite Accept? Output Correct? Accept? Output Correct? Yes Yes or No No Enter Yes or No Yes No Yes No B3 2 Format 3 2014-01-04 4 '20140104' 5 201414 6 2014-1-4 7 01/04/2014 8 DATE 2014-01-04 9 1 JAN 2014 10 Your format here 13 14 MySQL SQLite Accept? Output Correct? Accept? Output Correct? Yes Yes or No No Enter Yes or No Yes No Yes No