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

todate from text string
answered 02-12-2021 08:05:41 -0500

I have a string with date in the following format: 2017-02-08T16:17:10Z tried to use this function but it is NOT working to_timestamp('yyyy-MM-dd''T''HH:mm:ssZ', createdat) I also tried this: to_timestamp('yyyy-MM-dd''T''HH:mm:ss''Z', createdat) Wha...

Answers: 5

Date Conversion

Format Odd TEXT Date to Timestamp
answered 10-08-2021 17:57:31 -0400

I have a field called date that is coming in as text as the following format and I am having trouble converting it to a valid time stamp: 9 - Sep - 2019 19:35 Can anyone help with the formatting of the function?

Answers: 4

Date Conversion Date time stamp timestamp

Convert text to Timestamp
answered 13-05-2021 11:23:10 -0400

Hello. I am trying to convert a text to timestamp: My text has this format dd-MMM-yyyy HH:mm:ss I am using this function to_timestamp('dd-MMM-yyyy HH:mm:ss', bv_ho_orders.date_placed) When I convert to timestamp some of the dates are null. ...

Answers: 2

Date Conversion timestamp

Date subtraction
answered 12-05-2021 17:10:35 -0400

I am trying to subtract 4 months from the current date (without time) and then convert it to numeric value in the YYYYMMDD format. Looking at the manual (https://community.denodo.com/docs/html/browse/8.0/en/vdp/vql/language_for_defining_and_processing_...

Answers: 1

Date Conversion

How to convert a date in string format to interval date
answered 18-01-2021 05:54:50 -0500

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,

Answers: 1

Date Conversion VDP DENODO

Date format and Text to Date
answered 10-12-2020 07:57:00 -0500

Hi, I'm having one column named - EffectiveDate , which has field type as localdate. As denodo, by default shows date format in 'yyyymmdd', i'm using FORMATDATE('MM-dd-yyyy',EffectiveDate) command to change its format. Now, the field got changed into t...

Answers: 1

Date Conversion

SQL Server date datatypes error in conversion for base views
answered 15-06-2020 04:04:07 -0400

¡Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...

Answers: 1

Date Conversion datetime Base view Error SQL Server

SQL Server date conversion error in BaseView
answered 15-06-2020 04:02:11 -0400

Hello Support Team We are having a big stopper in a project with an odd issue for which we can't find a way to solve it. Technical data is and Consultant has already raised the same question: Source Server DataBase is SQLServer 2016. SQL Server...

Answers: 1

Date Conversion Base view VDP 7.0 SQL Server

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

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