Date/Time values from Collector

475
2
Jump to solution
12-14-2017 06:43 PM
Environment_SouthlandGIS_Servi
New Contributor II

Hi, 

We have had a problem when syncing Collector and the data is not showing up in our database.  I have managed to extract the data from the device and can view the data in a sql lite viewer.    I have extracted all the required data except the date and times.  They are showing in a sql lite viewer as e.g 2457800.55.

Does anybody know what time format this is/how to convert it?

I have 2 known records that show the correct time but cannot work out how to convert the rest.

e.g.

I know that:

2457800.549 = 16/02/2017 1:09:56 AM

2457800.55 = 16/02/2017 1:11:40 AM

Any help would be greatly appreciated.

Thanks.

0 Kudos
1 Solution

Accepted Solutions
XanderBakker
Esri Esteemed Contributor

It appears to be expressed in Julian Days. see for instance this online converter:

Online Conversion - Julian Date Converter 

... or you can use some python implementing existing modules like: julian 0.14 : Python Package Index 

View solution in original post

2 Replies
XanderBakker
Esri Esteemed Contributor

It appears to be expressed in Julian Days. see for instance this online converter:

Online Conversion - Julian Date Converter 

... or you can use some python implementing existing modules like: julian 0.14 : Python Package Index 

Environment_SouthlandGIS_Servi
New Contributor II

Perfect.  Thank you very much!!!

0 Kudos