@Rens Thanks for the solution. I have four date columns that I wanted to convert into NZST. Does that mean that I have to create four different functions (one for each datetime column) and then create four new columns that convert datetime to NZST using those queries. Am I right?