Q&A BY TAG 'TO_DATE function'

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

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

Date Format Transformation Pass Through Query in SAS
answered 22-08-2018 12:01:56 -0400

Hello, I have created a query in SAS that passes through Denodo via odbc connection (uses VQL syntax). My input date (effdate) is numeric with a length of 8 and looks like 20180815. I have tried numerous ways of converting it to a date. No matter what...

Answers: 3

Date Conversion TO_DATE TO_DATE function Date

Convert the incoming date in Text format to DateTime using the TO_DATE function
answered 27-06-2018 12:43:41 -0400

Hello, I have a question regarding the conversion of incoming Text format to a Denodo Date format using the TO_DATE function. The field name is <fld_name>. And, a sthe incoming date values are: 5/1/2018 1:41 PM 5/1/2018 12:59 PM 5/1/2018 11:45 ...

Answers: 1

Date Conversion TO_DATE function

Date conversion not working as expected
answered 26-04-2017 07:09:36 -0400

I have a NUMERIC source column which is in format “YYYYMMDD”. I am using TO_DATE function to convert into date. However the dates are not converted accurately using the function. The dates I have in the source column are 20170421 while the output of TO...

Answers: 1

TO_DATE function