Q&A BY TAG 'Date Conversion'
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
SQL Server date datatypes error in conversion for base views
answered
15-06-2020 04:04:07 -0400
¡Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...
Answers:
1
SQL Server date conversion error in BaseView
answered
15-06-2020 04:02:11 -0400
Hello Support Team We are having a big stopper in a project with an odd issue for which we can't find a way to solve it. Technical data is and Consultant has already raised the same question: Source Server DataBase is SQLServer 2016. SQL Server...
Answers:
1
Text (timestamp) to date
answered
01-06-2020 03:55:21 -0400
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 ...
Answers:
2
Text to Date field conversion
answered
27-02-2020 21:31:33 -0500
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 ...
Answers:
1
DATE / TIMESTAMP fields are not reflecting the i18n mapping change. Let us know if you need more info.
answered
29-01-2020 18:44:19 -0500
When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( ‘country’ = ‘US’ ‘datepattern’ = ‘MM/dd/yyyy’ ‘datesubtypepat...
Answers:
1
DATE / TIMESTAMP fields are not reflecting the i18n mapping change.
answered
28-01-2020 13:26:05 -0500
When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( 'country' = 'US' 'datepattern' = 'MM/dd/yyyy' 'datesubtypepa...
Answers:
1