Q&A BY TAG 'Dates'

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

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

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

denodo and R - Dates
answered 06-08-2019 07:56:40 -0400

Hi, For some reason on my computer and not my co-workers computer my R studio cannot read in dates from Denodo, It errors out and/or only brings in NA values. If you need screen shots please let me know.

Answers: 1