I needed to display local timestamps of UTC stored data in my report. But I didn't want to just blindly add or subtract hours as this wouldn't reflect
Reverse string search in Teradata
I needed to perform a reverse string search to find the last occurence of a slash. It took me a while before I found a simple and elegant solution