View Issue Details

IDProjectCategoryView StatusLast Update
0002032CaseTalk ModelerGeneration (SQL, XML, etc)public2022-01-10 20:40
ReporterBCP Software Assigned ToBCP Software  
PrioritynormalSeverityminorReproducibilitysometimes
Status closedResolutionfixed 
Target Version9.5.2Fixed in Version9.5.2 
Summary0002032: Denodo Dates in US format
DescriptionMost scripts are fine taking in US formatted populations. However Denodo uses a lot of text based value handling, and the date is not autmatically converted. The VQL is running on views which may have their own i18n definition. Therefor a straight forward date format is not always applicable.
Additional InformationPlease try generating a script using the "to_timestamp()" functions to declare the US notation of the text as hand.
TagsNo tags attached.
CaseTalk Editionunknown

Activities

BCP Software

BCP Software

2019-02-22 08:57

administrator   ~0001383

It now uses a TO_TIMESTAMP function to instruct Denodo how to load the data.
BCP Software

BCP Software

2022-01-10 20:40

administrator   ~0003723

Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved.

Issue History

Date Modified Username Field Change
2019-02-21 11:34 BCP Software New Issue
2019-02-21 11:34 BCP Software Status new => assigned
2019-02-21 11:34 BCP Software Assigned To => BCP Software
2019-02-22 08:57 BCP Software Status assigned => resolved
2019-02-22 08:57 BCP Software Resolution open => fixed
2019-02-22 08:57 BCP Software Fixed in Version => 9.5.2
2019-02-22 08:57 BCP Software Note Added: 0001383
2022-01-10 20:40 BCP Software Note Added: 0003723
2022-01-10 20:40 BCP Software Status resolved => closed