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

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

Date Conversion Base view datetime Error SQL Server

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

Date Conversion Base view VDP 7.0 SQL Server

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

Date Conversion Timezone conversion Dates Date

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 Conversion Date

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

Denodo 7.0 Date Conversion i18n

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 Conversion Denodo 7.0 i18n

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

Date Conversion Denodo 7.0 Data Type Conversion

Return Data for the past 6 months
answered 24-01-2020 07:32:35 -0500

Hi. I'd like to query the Denodo view via a querying tool (i.e. WinQSL) for the data from the last 6 months. I have tried the following, but I can't seem to get the Denodo syntax correct. select * from denodo_view where transaction_date >= getdate...

Answers: 1

Date Conversion Dynamic Dates Dates Date

How to Convert datatype from Text to Date?
answered 08-10-2019 21:18:06 -0400

HI Team, My base view has a date field which is in datatype text ( Varchar-50) and giving value '20190910172316' . I tried to convert the same to date by using " to_date('yyyyMMddhhmmss' , base_view.eff_dt ) as eff_dt " in derived view layer. it worke...

Answers: 1

Date Conversion

Format_date is not working for me to display 'yyyymm' patern
answered 26-07-2019 02:08:46 -0400

Hi Team, As per the customer requirement, I have to display only 'yyyymm' of a date field and I gave the expression as below in denodo: formatdate('yyyymm', dim_day.day_dt) But it gaves only the year, month displays as 00. For eg: 201800, 201900. I...

Answers: 2

Date Conversion Function TO_DATE function