Skip to main content
To homepage To homepage
SUBMITTED

Visualize datetime fields correctly in the Query tool

Related products:TimeXtender Data Integration
  • December 8, 2023
  • 0 replies
  • 26 views
P
Contributor
Forum|alt.badge.img+2

Hi,

The query tool incorrectly visualizes datetime fields as dates. We are using version 6346.1.

The workaround for this problem is to either cast the field as a varchar, or to do the queries in SSMS.

DW_TimeStamp has datatype “DateTime” but is being presented as a “Date” field in the Query tool 
In SSMS DW_TimeStamp is correctly presented as a “DateTime” field 

Appreciated if anyone had a look at this.

Best,

Pontus Berglund

Terms and ConditionsAccessibility statement