Caitlin Wrobel Posted September 13, 2019 Posted September 13, 2019 I modified the SQL of an information link to add a column to convert a datetime column from GMT to local time using a function that current works in Oracle SQL assistant. The information link works and opens with no errors however the new column I created in not included. I believe I am just missing something with the syntax as I have not ever created a new column in the Information Designer.
Caitlin Wrobel Posted September 13, 2019 Author Posted September 13, 2019 I resolved this by creating an element and putting the datamart utilities in the expression.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now