Q&A BY TAG 'Date'
Text (timestamp) to date
asked
30-05-2020 15:09:39 -0400
Hi. My view has a field with timestamp. Although, the field type is "text". I really only want to get a date from the field, but I don't know how. Here is an example of the text field: 2019-12-21T13:15:49.000-0600 2019-10-02T15:01:43.000-0500 I need ...
Answers:
0
Create new date field from a timestamp
asked
29-05-2020 17:31:58 -0400
Hi. I have two views in Denodo (in different datebases). I want to join the two on date (and another ID). However, the views do not have date, they only store timestamp. I want to get just the date from the timestamp in both views and join them. Here ...
Answers:
0
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 Range function does not work in path configuration
answered
31-01-2020 19:04:14 -0500
Based on this documentation: https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources When I try to put this in the file path of the data source: C:\Users...
Answers:
1
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
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
Get list of dates between two dates
answered
27-06-2019 05:45:54 -0400
How can I fetch all the list of dates between two dates ? Is there a system calendar that I can refer too ?
Answers:
1
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