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