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

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

Date format and Text to Date
answered 10-12-2020 07:57:00 -0500

Hi, I'm having one column named - EffectiveDate , which has field type as localdate. As denodo, by default shows date format in 'yyyymmdd', i'm using FORMATDATE('MM-dd-yyyy',EffectiveDate) command to change its format. Now, the field got changed into t...

Answers: 1

Date Conversion