Q&A BY TAG 'data types'

Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity
answered 08-01-2021 05:42:07 -0500

All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. <Error Description when retrieving data from De...

Answers: 1

ODBC Excel Microsoft Query DENODO data types

Floating points not recognized correctly
answered 20-06-2019 08:47:15 -0400

Hi guys, I'm working with VDP 7.0 and I have this CSV file that amongst other airport-related data contains latitude and longitude information. Here's a sample row of the dataset so you don't have to download the whole file: 34,"Castlegar/West Koote...

Answers: 3

CSV data types Data Type Conversion locale

How do I store "2014-12-31" as just a date, without the time and without a timezone?
answered 01-09-2015 10:08:11 -0400

Hi, I have a 3rd party web service that returns "2014-12-31" as one of the field values and I'd like to store it as a date in Denodo, (not a datetime: I don't want any timezone information stored nor time information... I just want the date). Can I s...

Answers: 1

date data types