I am trying to add a datetime into the database using an expression. I have managed this using the GETDATE() function, but how do I add 8hrs so the datetime appears in my local time instead of GMT?
The variant worked. Perfect solution. Now I can see when the records import into the database in my local time. Saves me from having to add this function when I query the table in the db. Thank you!