Q&A BY TAG 'Date Conversion'
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
Date Format Transformation Pass Through Query in SAS
answered
22-08-2018 12:01:56 -0400
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...
Answers:
3
Date Formatting
answered
21-08-2018 14:22:36 -0400
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...
Answers:
4
Odd Date Conversion
answered
01-08-2018 06:37:04 -0400
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...
Answers:
1
Convert the incoming date in Text format to DateTime using the TO_DATE function
answered
27-06-2018 12:43:41 -0400
Hello, I have a question regarding the conversion of incoming Text format to a Denodo Date format using the TO_DATE function. The field name is <fld_name>. And, a sthe incoming date values are: 5/1/2018 1:41 PM 5/1/2018 12:59 PM 5/1/2018 11:45 ...
Answers:
1
Getday/months function mask to two digits number
answered
23-10-2017 07:05:19 -0400
Hey denodo team, Is it possible to get a two digits number for those months that are lower to 10? I'm using the getday and getmonth functions to join both date fields (because they are on different times and I only want the date information). We use...
Answers:
3