Skip to main content
adey-21-Visitor
1-Visitor
April 10, 2017
Solved

time not updating when adding a data table entry

  • April 10, 2017
  • 2 replies
  • 1762 views

Hi

I am using ThingWorx 7.1.0-b484 with Postgres.

However I am using the default TW storage and I have noticed a strange behaviour in my data tables. Whenever a new entry is added to tje data table it reflects the date in the default column "timestamp" but does not reflect the time and shows the time as: 2017-04-10 00:00:00.000 for instance.

Kindly help in fixing this.

Best answer by posipova

This bug is Jira TW-7373. Fixed in 7.1.4 (and later), 7.2.0+, 7.3.0+.

This problem was occuring in the Postgres and H2 versions of the Platform because they populate the timestamp for Data Table entries using the java.sql.Date class which doesn't persist hours, minutes, seconds, and milliseconds.

2 replies

posipova20-TurquoiseAnswer
20-Turquoise
April 10, 2017

This bug is Jira TW-7373. Fixed in 7.1.4 (and later), 7.2.0+, 7.3.0+.

This problem was occuring in the Postgres and H2 versions of the Platform because they populate the timestamp for Data Table entries using the java.sql.Date class which doesn't persist hours, minutes, seconds, and milliseconds.

adey-21-VisitorAuthor
1-Visitor
April 11, 2017

thanks Polina!

Terms & ConditionsAccessibility statement