CODEWITHSUNDEEP
xsdmarklogicdatetime-formatbi-temporal
Hank
Hank

Reputation: 131

Is there an optimal timestamp format for querying bi-temporal data in MarkLogic?

I have two date formats for validStartDtTm (name of validAxes) stored in one collection. I want to harmonize all of the dates into one uniform format and wanted to know if there were any best practices for bi-temporal date format in MarkLogic.

Current formats are as follows:

  1. 2019-04-09T10:54:37.861434Z - generated by front end users and stored without transformation

  2. 2019-04-09T10:54:37.8614534-04:00 - ingested from back end with format 'DD/MM/YYYY HH:MM:SS' and transformed using xdmp.parseDateTime

Thanks!

Upvotes: 0

Views: 97

Answers (1)

wst
wst

Reputation: 11773

These are both valid xs:dateTime values so they don't need harmonization per se, but each indicates a different time zone, so you should check to be sure those are what is intended.

Both times are in the same format, The "Z" trailing the first time indicates "Zulu" time, i.e. UTC, the equivalent of 2019-04-09T10:54:37.861434-00:00. The "-04:00` trailing the second time indicates the time is behind USC by 4 hours and 0 minutes.

Upvotes: 2

Related Questions