• Find the number of days between December 21, 2020 (winter solstice), and March 21, 2021 (spring equinox).
• Put both dates in a table of constants, so they both have a datatype of date.
Starting points:
Oracle SQL
drop table ex0904a;
create table ex0904a
(beg_date date,
end_date date);
insert into ex0904a
values ('21-dec-2020', '21-mar-2021');
commit
select end_date - beg_date as number_of_days from ex0904a;
drop table ex0904a;
create table ex0904a
(beg_date datetime,
end_date datetime);
insert into ex0904a
values (#21-dec-2020#, #21-mar-2021#);
select end_date - beg_date as number_of_days from ex0904a;
Copyright © 2024 1QUIZZ.COM - All rights reserved.
Answers & Comments
Verified answer
Is there a question?
because we Pagans do not get our holidays off of work, we many times have a good time them the first day closest to the vacation in question that we do no longer ought to paintings. If it really is December twenty fifth, so be it. It in reality each and every now and then is although. traditionally, on December twenty fifth, my family contributors is going out for Arabic food and a movie. We do have a good time on the truly solstice as in many circumstances as available, although. it really isn't any longer continuously the 21st, you recognize. although, in spite of day it falls on, we many times do a small observance, in spite of if we do ought to paintings. I do have Christian family contributors too. on the twenty fourth, I continuously spend it with my mom's family contributors. we've dinner and open presents. The weekend beforehand, I spend with my Grandmother's family contributors (it truly is, the full mess human beings) and we've a huge dinner then too. If any of those fall on the Solstice, it receives pre-empted. The Gods want to be venerated, yet they need us to honor our family contributors better. And, for the list- in some traditions, that isn't any longer the 21st, or the Solstice, that is the twenty fifth. The birthday of the daylight.