Latest Activity

code

Convert calenderweek and year to date

Hi guys, I am facing the following converting issue in denodo. I have to convert the formats yyww, yyyyww, wwyy and ww/yy into the date 'dd.MM.yyyy'. Does anyone of you have an solution for this problem I am facing right now? Thanks Johannes

calenderweek date year convert to

code

First of previous month

how do i get first of previous month? addmonth(current_date(),-1) provides exactly one month ago , but how do i set to always get 1st. for example, from 4/1-4/30, want to pull from 3/1.

Date

code

SQL Start & End Dates of Previous Quarter

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 ...

Date

code

Conviert to Denodo for Altyrex

Hello, I am trying to convert this code to Denodo MEWM_TERM_DT >= dateadd(day,-1,convert(Date, getdate(), 365)) plese assist

Date

code

Month integer to Month name

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

date formatdate monthinteger monthtext

code

oracle "date" column convert to "timestamp" column in Denodo

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...

date oracle timestamp

code

Teradata to denodo sql

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

date

code

Text (timestamp) to date

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 ...

Date Conversion Timezone conversion Dates Date

code

Create new date field from a timestamp

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 ...

Date timestamp

code

Text to Date field conversion

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 ...

Date Conversion Date