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

Date Time issue
answered 03-12-2018 18:39:04 -0500

Hi Experts, My date table is in UTC and date column doesnt have any time stamp in source db. in VDB it is defined as Date column. when I query this table from EST it is converting to EST time zone and showing(Example: Date column--> Mon Feb 20 19:0...

Answers: 3

Date Conversion

Filtering between Current_Date and Current_Date - x days
answered 24-08-2018 10:49:12 -0400

I'm looking to filter a query by dates. The date (my_dt) within the table I'm pulling from is in the format yyyyMMdd but as type numeric and length of 8. So, what I'm trying to do is filter where my_dt is between a date that is x days ago from today an...

Answers: 1

Date Conversion Date

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

Date Formatting
answered 21-08-2018 14:22:36 -0400

Hello, Here is my issue. I am working in Alteryx, pulling a table from Denodo. I'm looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I'm looking to convert are like such. 9101...

Answers: 4

Date Conversion Date

Odd Date Conversion
answered 01-08-2018 06:37:04 -0400

Hello, I’m looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I’m looking to convert are like such. 910101 is an example of the date value. This is equivalent to Jan 1, 1991. B...

Answers: 1

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

Getday/months function mask to two digits number
answered 23-10-2017 07:05:19 -0400

Hey denodo team, Is it possible to get a two digits number for those months that are lower to 10? I'm using the getday and getmonth functions to join both date fields (because they are on different times and I only want the date information). We use...

Answers: 3

Date Conversion Data Mask getday

Converting a Julian date stored in an Oracle DB as a NUMBER to a 'date' data type
answered 17-05-2017 10:22:56 -0400

Has anyone successfully implemented a function for converting a Julian date stored as a NUMBER in the RDBMS to a 'date' as used by VDP? I wasn't able to find any help. I found some imperative algorithms for doing so, but nothing easily converted to a d...

Answers: 2

Date Conversion VDP

Issue with CONTEXT date conversion with call from a REST Webservice
answered 28-04-2017 06:30:57 -0400

I am getting the following error when I execute a the following query from a REST Web Service to a view in Denodo: SELECT_NAVIGATIONAL <fields> FROM <denodo derived view> WHERE (1=1 and (Rcvd_Date BETWEEN DATE '0001-01-01' AND DATE '9999-12...

Answers: 1

Date Conversion dateformat

Converting ORACLE Data Data Type to Integer in Denodo
answered 13-03-2017 10:42:30 -0400

Hi, I am using an ORACLE table as my data source and need to convert DATE data type to integer format (YYYYMMDD). I tried using the syntax below and getting an error in Denodo. CAST(CONVERT(VARCHAR(8), address_01_filtered.add_from, 112) AS INTEGER) ...

Answers: 2

Date Conversion Data Type Conversion