Q&A BY TAG 'datatypes'

You must sign in to ask a question. If you do not have an account, you can register here

Format date datatype
answered 17-12-2021 12:32:39 -0500

I am using denodo studio version 8 and we are doing POC where trying to match capabilities between our current DV tool with denodo. in current dv tool we have syntax to parse date coming with AM, PM to date(mm/dd/yyyy) format and I amtrying to do the s...

Answers: 4

formatdate datatypes

Date Data Type Issue
answered 08-11-2019 19:05:52 -0500

Hi Team, Please share Denodo 6.0 Manaul URL where I can read about Denodo Data types I have a SQL Server Table, which has fields in date data type. When I create base view, those date fields are converted to text. Why ? How to keep them in date ...

Answers: 1

Date datatypes

non-ANSI data types
answered 14-01-2019 11:00:08 -0500

Hallo Denodo Team, Some Databases (Teradata for one) add non-ANSI extensions to the set of available data types. Is there a way to predict with certainty how such types would be translated into Denodo types at “base view creation time”? Thank you in...

Answers: 1


Join attributes of different (compatible) types across different data sources
answered 07-01-2019 07:40:30 -0500

Hallo Denodo Team, Suppose you need to join tables from different data sources (say Oracle and Teradata). Suppose the matching should happen between attributes that have different data types (say VARCHAR(N) on one side, NVARCHAR(m) on the other side, ...

Answers: 1

join datatypes

Datatype Issue while creating a base view from SQL Server
answered 10-05-2018 03:00:38 -0400

I have a table in Sql server with a column of date datatype. For this instance : Create table table_name ( dob date ) ; I have created base view on top of this table. But in base view, datatype of dob as text datatype in denodo which is not expected...

Answers: 1

DENODO MSSQL SQLServer Date datatypes sql server

answered 07-09-2016 10:47:51 -0400

when i load the date field in denodo it shows like 'wed dec 17 00:00:00 IST 1980' but i have given only 'yyyy-MM-dd' in database. How to display date with format 'yyyy-MM-dd' in date datatype only as when i am using formatdate() function it changes the...

Answers: 1

date functions dateformat datatypes