How do you convert UTC to local time?

I've been told the sql server I'm using uses UTC for its data time fields. The adjustment is -7 hours to show local time in the data base.

Is there an Aleryx tool that can help me with this conversion or how would I write the sql code to adjust for the 7 hour difference?

Any help will be greatly appreciated.

Date Time

Accepted answers

You could add a Formula tool with the following expression:

DateTimeAdd([DateTime], -7, 'hours')

Let me know if you have any questions, or this isn't quite what you were looking for

You could add a Formula tool with the following expression:

DateTimeAdd([DateTime], -7, 'hours')

Let me know if you have any questions, or this isn't quite what you were looking for

Your suggestion started me looking at the date time functions and I found one built to convert UTC code.

Here it is: DateTimeToLocal([datetime])

I put this into a formula tool and it worked perfectly for my time zone.

Thanks for all the help.