Q&A BY TAG 'Date Conversion'
Convert text to Timestamp
answered
05-05-2021 17:50: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:
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
DATE fields being converted to TIMESTAMP in Denodo.
answered
24-01-2020 15:28:35 -0500
While creating base views from data source (oracle), denodo converts all DATE fields to TIMESTAMP. When we try to access these date fields from any JDBC client in our case 'DBeaver' we get these fields as TIMESTAMP and not 'DATE' fields. Is there a way...
Answers:
2