Q&A BY TAG 'Date Conversion'
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
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 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
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
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
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
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 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
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 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