You can translate the question and the replies:

Date

when i load the date field in denodo it shows like 'wed dec 17 00:00:00 IST 1980' but i have given only 'yyyy-MM-dd' in database. How to display date with format 'yyyy-MM-dd' in date datatype only as when i am using formatdate() function it changes the data type into text and this only works in derived views as there i can add any function in field expression window ? How to view date in required or Database format in base view and derived views (without changing data type i.e using formatdate() function) ?
date functions dateformat datatypes
user
06-09-2016 03:34:41 -0400
code

1 Answer

Hi, Denodo uses internationalization configuration to specify timezone and time information to display date field type data. You can find it by navigating to Tools > Admin Tool Preferences > Locale, inside the VDP admin tool menu bar to change your configuration. If you think the list of available configurations is not suitable you can also create a new ad hoc configuration. A quick read of the section titled CONFIGURING THE DEFAULT INTERNATIONALIZATION in Virtual DataPort Administration Guide and CREATING NEW INTERNATIONALIZATION CONFIGURATIONS in Advanced VQL Guide could be useful to you with more information. Hope this helps!
Denodo Team
07-09-2016 10:47:51 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here