You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We are in the process of migrating to lb4 and one issue we encountered is that Date fields that are stored in oracle as UTC are being converted to local time on retrieval instead of remaining in UTC for the client to handle.
Ex:
Local time: "2022-08-19T15:38:45.000-04:00"
Value sent in on a POST: "2022-08-19T19:38:45.000Z"
Value returned on a GET: "2022-08-19T23:38:45.000Z"
Has anyone else seen this and know how to get around it? I've spent far too many hours trying to get to the bottom of this and the most I know at this point is that the connector saves as UTC but doesn't reverse that on retrieval but, instead, interprets the value as local time.
As an added note, we have one table that is populated from outside of loopback by another process and it is storing it in local time but that data still needs to be retrieved by loopback for reads.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
We are in the process of migrating to lb4 and one issue we encountered is that Date fields that are stored in oracle as UTC are being converted to local time on retrieval instead of remaining in UTC for the client to handle.
Ex:
Local time: "2022-08-19T15:38:45.000-04:00"
Value sent in on a POST: "2022-08-19T19:38:45.000Z"
Value returned on a GET: "2022-08-19T23:38:45.000Z"
Has anyone else seen this and know how to get around it? I've spent far too many hours trying to get to the bottom of this and the most I know at this point is that the connector saves as UTC but doesn't reverse that on retrieval but, instead, interprets the value as local time.
As an added note, we have one table that is populated from outside of loopback by another process and it is storing it in local time but that data still needs to be retrieved by loopback for reads.
Beta Was this translation helpful? Give feedback.
All reactions