Q&A BY TAG 'Dates'

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

How to convert a date and time to another format?
answered 09-09-2020 05:51:13 -0400

Hi! I would like to know how to convert a column with a date format such as dd/MM/YYYY 12:00:00 a.m to a format where only shows "dd/MM/YYYY". I have used the function FORMATDATE('dd/MM/YYYY, datecolumn) and although it gives me the format that I want ...

Answers: 1

Timezone conversion Dates Questionable

formatting date to ddMMMyyyy which is equivalent to date9
answered 17-07-2020 07:56:14 -0400

Good day I have a datetime format represented as 07DEC2005:00:00:00.000000 please note this is a date not character. I now want to convert to 'ddMMMyyyy' but still to be in a date format not as text or character. i have tried this sql code formatdate...

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

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