Skip to main content
Question

Milliseconds are lost when reading from Geopackage?

  • August 30, 2023
  • 1 reply
  • 18 views

chau
Contributor
Forum|alt.badge.img+3
  • Contributor
  • 37 replies

I have used FME 2022.2.5 to write datetimes with millisecond accuracy to a Geopackage. But when I try to use the same FME and a FeatureReader to read the datetimes from the Geopackage I get truncated datetimes with second accuracy.

 

When I use the SQLite format in the FeatureReader when reading the features, the datetimes include millisecond accuracy.

 

I have inspected the Geopackage using DBeaver and there I can see the datetimes with milliseconds and the type is DATETIME.

 

I would expect FME to be able to read DATETIME's from a Geopackage file with millisecond accuracy, but that might not be the case?

 

Regards, Casper

 

 

1 reply

daveatsafe
Safer
Forum|alt.badge.img+19
  • Safer
  • 1637 replies
  • August 30, 2023

Hi @Casper Børgesen​,

FME is converting the Geopackage internal SQLite datetime to an FME datetime for convenience, but in doing so is truncating to the nearest second. I am escalating this to a support case, so we can look at changing the conversion settings.