Hesloan Viana Posted December 13, 2019 Share Posted December 13, 2019 Hey all, i'm having a problem where the column DATE_O and DATE_C, both datetime, are going to spotfire like 'DD:MM:YY 00:00:00' but the query sends the correct format like the attachments. Link to comment Share on other sites More sharing options...
Seema Krishnani Posted December 15, 2019 Share Posted December 15, 2019 What is the data source type e.g. SQL, Oracle etc and are you using JDBC, ODBC, connector Link to comment Share on other sites More sharing options...
Hesloan Viana Posted December 16, 2019 Author Share Posted December 16, 2019 Oracle data source, and i'm using ODBC connector. Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted March 9, 2020 Share Posted March 9, 2020 Check the datatype in query/data connection dialog, does it show date or datetime You can create custom query like select * from abc then verify it and check the preview to see what data it is showing. If it still does not match with that in db, inspite of above checks, please raise support case. 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