Q&A BY TAG 'Date Conversion'
Text to Date field conversion
answered
27-02-2020 21:31:33 -0500
Hi Team, Using Denodo 7.0 version. I have date field in format 'MM/dd/yyyy' in my source which is in text datatype. I need to project the same in same format('MM/dd/yyyy') but in date datatype. When i use CAST, to_date ,to_localdate ....., format is ...
Answers:
1
DATE / TIMESTAMP fields are not reflecting the i18n mapping change. Let us know if you need more info.
answered
29-01-2020 18:44:19 -0500
When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( ‘country’ = ‘US’ ‘datepattern’ = ‘MM/dd/yyyy’ ‘datesubtypepat...
Answers:
1
DATE / TIMESTAMP fields are not reflecting the i18n mapping change.
answered
28-01-2020 13:26:05 -0500
When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( 'country' = 'US' 'datepattern' = 'MM/dd/yyyy' 'datesubtypepa...
Answers:
1
DATE fields being converted to TIMESTAMP in Denodo.
answered
24-01-2020 15:28:35 -0500
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...
Answers:
2
Return Data for the past 6 months
answered
24-01-2020 07:32:35 -0500
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...
Answers:
1
How to Convert datatype from Text to Date?
answered
08-10-2019 21:18:06 -0400
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...
Answers:
1
Format_date is not working for me to display 'yyyymm' patern
answered
26-07-2019 02:08:46 -0400
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...
Answers:
2
OData2 Wrapper converting DateTime to "Local" DateTime?
answered
01-07-2019 09:00:51 -0400
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...
Answers:
1
Date Time issue
answered
03-12-2018 18:39:04 -0500
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...
Answers:
3
Filtering between Current_Date and Current_Date - x days
answered
24-08-2018 10:49:12 -0400
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...
Answers:
1