Q&A BY TAG 'Date'
SQL Start & End Dates of Previous Quarter
answered
28-12-2022 14:20:27 -0500
Hello - what is the syntax for start and end dates of the previous quarter? For example, if the current date is a day in December, the start date should be '2022-07-01', the end date should be '2022-09-30'. If the current date is a day in January, the ...
Answers:
1
Conviert to Denodo for Altyrex
answered
14-07-2022 14:29:03 -0400
Hello, I am trying to convert this code to Denodo MEWM_TERM_DT >= dateadd(day,-1,convert(Date, getdate(), 365)) plese assist
Answers:
1
Month integer to Month name
answered
07-06-2022 08:09:45 -0400
I have a column with values of month numbers called "month" 01 02 03 I want the results to be of months name Jan Feb Mar, How to achieve this
Answers:
4
oracle "date" column convert to "timestamp" column in Denodo
answered
15-12-2020 05:45:51 -0500
Hi team, I have view sourced from oracle, which contains date type column, when created this view, denodo converted the date column to "timestamp" automatically, and when tried to convert it to "localdate", the error is showing "the field has an incomp...
Answers:
1
Teradata to denodo sql
answered
04-08-2020 07:16:22 -0400
how to convert the below syntax from teradata to denodo sql (DATE-1 - DAYOFMONTH(DATE-1))+1 (DATE-1 - Extract(Day from DATE-1))+1
Answers:
1
Text (timestamp) to date
answered
01-06-2020 03:55:21 -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:
2
Create new date field from a timestamp
answered
01-06-2020 03:45:27 -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:
2
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