Q&A BY TAG 'Date Conversion'

You must sign in to ask a question. If you do not have an account, you can register here

Interpolation Variable - Date function
answered 09-11-2022 13:21:04 -0500

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

Answers: 2

Date Conversion Interpolation Variables DB2

TEXT to DATE conversion questions
answered 25-04-2022 08:23:31 -0400

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

Answers: 1

Date Conversion

timestamp to date
answered 25-03-2022 01:07:30 -0400

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.

Answers: 4

Date Conversion

Date format
answered 15-02-2022 23:53:54 -0500

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

Answers: 1

Date Conversion

Problems in converting oracle math operation and the concatenation operator
answered 09-02-2022 04:57:35 -0500

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

Answers: 1

Date Conversion concatenate Oracle

todate from text string
answered 02-12-2021 08:05:41 -0500

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

Answers: 5

Date Conversion

Format Odd TEXT Date to Timestamp
answered 10-08-2021 17:57:31 -0400

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?

Answers: 4

Date Conversion Date time stamp timestamp

Convert text to Timestamp
answered 13-05-2021 11:23:10 -0400

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

Answers: 2

Date Conversion timestamp

Date subtraction
answered 12-05-2021 17:10:35 -0400

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

Answers: 1

Date Conversion

How to convert a date in string format to interval date
answered 18-01-2021 05:54:50 -0500

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,

Answers: 1

Date Conversion VDP DENODO