I discovered a function in our database that converts integers to ordinals by concatenating the number and a suffix:
- ends in 1: add “st”
- ends in 2: add “nd”
- ends in 3: add “rd”
- else: add “th”
Simple! Except I guess nobody considered the 11st, 12nd, and 13rd iteration of this function…