|
Posted by --CELKO-- on 10/24/05 06:47
create a table of the quarters:
CREATE TABLE Quarters
(quarter_name CHAR(20) NOT NULL PRIMARY KEY,
start_date DATETIME NOT NULL,
end_date DATETIME NOT NULL,
CHECK (start_date < end_date ));
>> .. determine the closest quarter to it. <<
Whatr does thst mean? give me an algorithm.
Navigation:
[Reply to this message]
|