Latest Activity

code

DATE fields being converted to TIMESTAMP in Denodo.

While creating base views from data source (oracle), denodo converts all DATE fields to TIMESTAMP. When we try to access these date fields from any JDBC client in our case 'DBeaver' we get these fields as TIMESTAMP and not 'DATE' fields. Is there a way...

Date Conversion Denodo 7.0 Data Type Conversion

code

Return Data for the past 6 months

Hi. I'd like to query the Denodo view via a querying tool (i.e. WinQSL) for the data from the last 6 months. I have tried the following, but I can't seem to get the Denodo syntax correct. select * from denodo_view where transaction_date >= getdate...

Date Conversion Dynamic Dates Dates Date

code

How to Convert datatype from Text to Date?

HI Team, My base view has a date field which is in datatype text ( Varchar-50) and giving value '20190910172316' . I tried to convert the same to date by using " to_date('yyyyMMddhhmmss' , base_view.eff_dt ) as eff_dt " in derived view layer. it worke...

Date Conversion

code

Format_date is not working for me to display 'yyyymm' patern

Hi Team, As per the customer requirement, I have to display only 'yyyymm' of a date field and I gave the expression as below in denodo: formatdate('yyyymm', dim_day.day_dt) But it gaves only the year, month displays as 00. For eg: 201800, 201900. I...

Date Conversion Function TO_DATE function

code

OData2 Wrapper converting DateTime to "Local" DateTime?

I have been using a JSON data source and switched to a custom wrapper for Odata3 (using OData2 custom wrapper with headers 'Content-type="application/json";Accept="application/json";DataServiceVersion="2.0";MinDataServiceVersion="2.0";MaxDataServiceVer...

ODATA OData Date Conversion Timezone conversion json JSON

code

Date Time issue

Hi Experts, My date table is in UTC and date column doesnt have any time stamp in source db. in VDB it is defined as Date column. when I query this table from EST it is converting to EST time zone and showing(Example: Date column--> Mon Feb 20 19:0...

Date Conversion

code

Filtering between Current_Date and Current_Date - x days

I'm looking to filter a query by dates. The date (my_dt) within the table I'm pulling from is in the format yyyyMMdd but as type numeric and length of 8. So, what I'm trying to do is filter where my_dt is between a date that is x days ago from today an...

Date Conversion Date

code

Date Format Transformation Pass Through Query in SAS

Hello, I have created a query in SAS that passes through Denodo via odbc connection (uses VQL syntax). My input date (effdate) is numeric with a length of 8 and looks like 20180815. I have tried numerous ways of converting it to a date. No matter what...

Date Conversion TO_DATE TO_DATE function Date

code

Date Formatting

Hello, Here is my issue. I am working in Alteryx, pulling a table from Denodo. I'm looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I'm looking to convert are like such. 9101...

Date Conversion Date

code

Odd Date Conversion

Hello, I’m looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I’m looking to convert are like such. 910101 is an example of the date value. This is equivalent to Jan 1, 1991. B...

Date Conversion Date