You can translate the question and the replies:

Text to Date field conversion

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 changing. And we know, *formatdate* function will give output as text format, so there's no point of using it as mine is already in text format. is there any function in denodo to get the value in same format with date datatype . Please help. Thanks in advance.
user
25-02-2020 00:51:53 -0500

1 Answer

Hi, The format of the “date type” in Denodo 7.0 is standardized and will always appear as yyyy-MM-dd in the Virtual DataPort Administration Tool. For this scenario, I would use the [FORMATDATE](https://community.denodo.com/docs/html/browse/latest/vdp/vql/appendix/syntax_of_condition_functions/date_processing_functions#formatdate) function to change to a desired date format as text. Another option is to modify the date format within the consuming applications (such as JDBC clients or BI tools). For more information about changes to date types in Denodo 7.0, you can take a look at the [Changes in Date Types](https://community.denodo.com/docs/html/browse/7.0/platform/migration/backward_compatibility/changes_in_the_denodo_platform_7.0/changes_in_virtual_dataport#changes-in-date-types) section of the Denodo Platform Migration Guide. If you are a valid support user and need further assistance for this scenario, you can open a Support case and the Support Team will help you further. Hope this helps!
Denodo Team
27-02-2020 21:31:33 -0500
You must sign in to add an answer. If you do not have an account, you can register here