Caitlin Wrobel Posted September 13, 2019 Share 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. Link to comment Share on other sites More sharing options...
Caitlin Wrobel Posted September 13, 2019 Author Share Posted September 13, 2019 I resolved this by creating an element and putting the datamart utilities in the expression. Link to comment Share on other sites More sharing options...
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