Unanswered: MS Query Analyzer: how to calculate a time span with two DATETIMES?
Hi there, we have an assignment in school and one of the questions is to show the years of work experience that some nurses have.
I have figured out that if you have two columns that are the DATETIME datatype (which we have in the assignment), you can subtract one from another to get a date. I did a little test and it comes back as Jan xx 1900, where xx is the number of days.
I did this:
CREATE TABLE DateTest (
INSERT INTO DateTest VALUES ('april 17 2002', 'april 20 2002')