MySQL Functions

Sample MySQL functions that could be used on any particular project if need arises

• get_first

  Gets the first length characters from a given string

• calculate_age

  Calculates the age of something or someone in terms of years relative to the current date

• get_num_of_days

  Calculates the difference in terms of days between two dates

• get_num_of_months

  Calculates the difference in terms of months between two dates

• get_num_of_years

  Calculates the difference in terms of years between two dates

• get_time_difference

  Calculates the difference in terms of years or month or days between two dates