Q&A BY TAG 'formatdate'

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

Month integer to Month name
answered 07-06-2022 08:09:45 -0400

I have a column with values of month numbers called "month" 01 02 03 I want the results to be of months name Jan Feb Mar, How to achieve this

Answers: 4

date formatdate monthinteger monthtext

Format date datatype
answered 17-12-2021 12:32:39 -0500

I am using denodo studio version 8 and we are doing POC where trying to match capabilities between our current DV tool with denodo. in current dv tool we have syntax to parse date coming with AM, PM to date(mm/dd/yyyy) format and I amtrying to do the s...

Answers: 4

formatdate datatypes

Data catalog change timestamp type fields format
answered 01-12-2020 07:06:36 -0500

Hello, Currently when we query views containing fields of type "timestamp" in our Data Catalog, the data in these fields is formated in an odd way like the following example: Mon Dec 05 09:52:00 2005 When querying the same view through the VDP...

Answers: 3

formatdate Data Catalog formatting timestamp