On 4/13/23 08:31, Sebastien Flaesch wrote:
>From the investigation we did here, I can confirm that the number in
AJAX Date is the milliseconds since Epoch (1970-01-01 00:00:00), and
it's always in UTC, even if there is a timezone offset provided. I
mention this because it's different from ISO 8601 datetimes, where the
datetime part is in local time corresponding to the offset, when one is
specified (check https://momentjs.com/docs/#/parsing/asp-net-json-date/
<https://momentjs.com/docs/#/parsing/asp-net-json-date/>)
So, is there some built-in JSON API in PostgreSQL to convert an AJAX
Date from JSON or do I have to do this by hand?
By hand as this is a MS/ASP thing:
https://weblogs.asp.net/bleroy/dates-and-json
not a JSON thing.
Seb
------------------------------------------------------------------------
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
