Updated the init_db.sql script to change date column types to date. For the already created DB, I used the following script to alter the tables:
alter table <tablename> alter column <columnname> type DATE using to_date(<columnname>, 'YYYY-MM-DD');
After doing that, I noticed one of the unit tests was failing due to the query output order, so I created #99 and made sure every getter query has an explicit order that makes sense.
Updated the init_db.sql script to change date column types to date. For the already created DB, I used the following script to alter the tables:
alter table <tablename> alter column <columnname> type DATE using to_date(<columnname>, 'YYYY-MM-DD');After doing that, I noticed one of the unit tests was failing due to the query output order, so I created #99 and made sure every getter query has an explicit order that makes sense.
Closes #97 closes #99