[OLINGO-1456] Olingo returns DateTime or Timestamp values in a wrong format

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: V2 2.0.11
• Component/s: odata2-jpa
• Environment: windows, mysql, spring boot 2.3.0
• Assignee: Unassigned
• Reporter: Mahdi Ansari
• Created: 03/Jun/20 10:16
• Updated: 03/Jun/20 11:25
• Resolved: 03/Jun/20 11:25

Description

I made an odata service with Olingo2/JPA and spring-boot based on this GitHub repository(https://github.com/jpenninkhof/odata-boilerplate).

The problem is olingo does not return the date/time or timestamp columns in a correct format as defined in Odata standard (or maybe Microsoft standard). I mean my front-end library (i.e. OpenUI5) expects some value like `<d:ValidFrom>/Date(1579075200000)/</d:ValidFrom>` for `Edm.DateTime` column but what olingo returns is `<d:ValidFrom>2020-01-15T08:00:00</d:ValidFrom>` which is not accepted by OpenUI5!

What is your suggestion?

Is there a way that I force Olingo to return data/time or timestamp in the format that Microsoft defined or not? (i.e. `/Date(timestamp)/`)