Latest Activity

code

Interpolation Variable - Date function

Hi, I am trying to create a base view with query from DB2 in which I included 2 parameters Begin_date, End_date that are added in where clause to filter Date(confirm_date) column. Example: Select * from Table where Date_column between @Begin_date and ...

Date Conversion Interpolation Variables DB2

code

TEXT to DATE conversion questions

I am using Denodo 8.0 and have two different date conversion questions. First scenario I have a “date” field that is defined as a TEXT type on the source file. The format is dd-MMM-yy. I want it to be a localdate type (yyyy-MM-dd) I am trying to conv...

Date Conversion

code

timestamp to date

Hi Team, How to convert timestamp to date ? from: 2022-02-17 09:23:13 to: 2022-02-17 Denodo 7.0 update 20210224 Thanks.

Date Conversion

code

Date format

Hello Team, I have a request to expose a date for a client to this formt "yyy-MM-ddT00:00:00.000Z" the OriginalDate is like "2022-02-08T00:00:00" i used the following function but in the result the 'Z' doesn't appear: formatdate('yyyy-MM-dd''T''HH:m...

Date Conversion

code

Problems in converting oracle math operation and the concatenation operator

Hi support team, I'm having trouble putting this query into my view WHERE CONDITIONS, there is an AND Operators in front of the line This is my original query from oracle ... AND datedata+(8/24)>=todate(tochar((sysdate+16/24)-1,'YYYY-MM-DD')|| '00...

Date Conversion concatenate Oracle

code

todate from text string

I have a string with date in the following format: 2017-02-08T16:17:10Z tried to use this function but it is NOT working to_timestamp('yyyy-MM-dd''T''HH:mm:ssZ', createdat) I also tried this: to_timestamp('yyyy-MM-dd''T''HH:mm:ss''Z', createdat) Wha...

Date Conversion

code

Format Odd TEXT Date to Timestamp

I have a field called date that is coming in as text as the following format and I am having trouble converting it to a valid time stamp: 9 - Sep - 2019 19:35 Can anyone help with the formatting of the function?

Date Conversion Date time stamp timestamp

code

Convert text to Timestamp

Hello. I am trying to convert a text to timestamp: My text has this format dd-MMM-yyyy HH:mm:ss I am using this function to_timestamp('dd-MMM-yyyy HH:mm:ss', bv_ho_orders.date_placed) When I convert to timestamp some of the dates are null. ...

Date Conversion timestamp

code

Date subtraction

I am trying to subtract 4 months from the current date (without time) and then convert it to numeric value in the YYYYMMDD format. Looking at the manual (https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/language_for_defining_and_processing_...

Date Conversion

code

How to convert a date in string format to interval date

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,

Date Conversion VDP DENODO