Thank you for the responses, i apriciate all the help i can get. However, my code example only made a database to illustrate the problem. In a real world scenario, i have a already existing database ...

Add an SQL function to convert a date or timestamp to a string. The java.time.format.DateTimeFormatter class will be used to do the conversion and format will be a pattern used by ...