Q&A BY TAG 'Date'

You must sign in to ask a question. If you do not have an account, you can register here

oracle "date" column convert to "timestamp" column in Denodo
answered 15-12-2020 05:45:51 -0500

Hi team, I have view sourced from oracle, which contains date type column, when created this view, denodo converted the date column to "timestamp" automatically, and when tried to convert it to "localdate", the error is showing "the field has an incomp...

Answers: 1

date oracle timestamp

Month integer to Month name
answered 03-09-2020 04:59:32 -0400

I have a column with values of month numbers called "month" 01 02 03 I want the results to be of months name Jan Feb Mar, How to achieve this

Answers: 2

date formatdate monthinteger monthtext

Teradata to denodo sql
answered 04-08-2020 07:16:22 -0400

how to convert the below syntax from teradata to denodo sql (DATE-1 - DAYOFMONTH(DATE-1))+1 (DATE-1 - Extract(Day from DATE-1))+1

Answers: 1

date

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

Create new date field from a timestamp
answered 01-06-2020 03:45:27 -0400

Hi. I have two views in Denodo (in different datebases). I want to join the two on date (and another ID). However, the views do not have date, they only store timestamp. I want to get just the date from the timestamp in both views and join them. Here ...

Answers: 2

Date timestamp

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 Range function does not work in path configuration
answered 31-01-2020 19:04:14 -0500

Based on this documentation: https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/delimited_file_sources/delimited_file_sources When I try to put this in the file path of the data source: C:\Users...

Answers: 1

DateRange Date

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

Date Data Type Issue
answered 08-11-2019 19:05:52 -0500

Hi Team, Please share Denodo 6.0 Manaul URL where I can read about Denodo Data types I have a SQL Server Table, which has fields in date data type. When I create base view, those date fields are converted to text. Why ? How to keep them in date ...

Answers: 1

datatypes Date

Get list of dates between two dates
answered 27-06-2019 05:45:54 -0400

How can I fetch all the list of dates between two dates ? Is there a system calendar that I can refer too ?

Answers: 1

Date