VINAYAK ANAND

VINAYAK ANAND

  • NA
  • 1
  • 2.9k

DATE DIFF QUERY IN SQL SERVER

Oct 19 2012 12:39 PM
I AM HAVING A TABLE NAME PERSONAL , IN A TABLE I AM HAVING TWO COLUMNS NAMED DATE OF BIRTH (DOE) AND DATE OF ENROLLMENT, NOW I WANT TO TAKE OUT ACTUAL DIFFERENCE BETWEEN THE TWO COLUMNS  IN YEARS MONTHS AND DATE. FOR EXAMPLE


DOB                            DOE                           ANSWER SHOULD BE LIKE THIS

09 FEB 1981              26 SEP 2003              09YRS   03MTS   12DAYS


SOMEBODY HELP ME OUT OF THIS PLZ


AN EARLY ANSWER WILL BE HIGHLY APPRECIATED!!!!!!!!!!!!!!!!!

Answers (2)