SQL Server User-Defined Date Functions

• Get Age Function

  ---

  Computes for the age given the birth date and the reference date.

• Get Date Only

  ---

  Returns the input date removing the time portion.

• Get First Day of the Week

  ---

  Returns the first day of the week for a given date.

• Get First Day of the Month

  ---

  Returns the first day of the month for a given date.

• Get First Day of the Quarter

  ---

  Returns the first day of the quarter for a given date.

• Get Last Day of the Month

  ---

  Returns the last day of the month for a given date.

• Get Number of Days in a Month

  ---

  Returns the number of days in a month.

• Get Number of Days in a Year

  ---

  Returns the number of days in a year.

• Determine Leap Year Function

  ---

  Computes for the age given the birth date and the reference date.