O'Reilly logo
  • YASHODA SINGAMSETTY thinks this is interesting:

Use subtraction to return the number of days between ALLEN_HD and WARD_ HD. Then multiply to find each unit of time:

From

Cover of SQL Cookbook

Note

BETWEEN TWO DATES