On 2023-04-15 09:12:41 -0700, Adrian Klaver wrote:
> On 4/15/23 03:46, Peter J. Holzer wrote:
> > On 2023-04-14 10:44:08 -0700, Adrian Klaver wrote:
> > > On 4/14/23 9:31 AM, Peter J. Holzer wrote:
> > > > On 2023-04-13 10:07:09 -0500, Ron wrote:
> > > > > On 4/13/23 09:44, Sebastien Flaesch wrote:
On 4/15/23 03:46, Peter J. Holzer wrote:
On 2023-04-14 10:44:08 -0700, Adrian Klaver wrote:
On 4/14/23 9:31 AM, Peter J. Holzer wrote:
On 2023-04-13 10:07:09 -0500, Ron wrote:
On 4/13/23 09:44, Sebastien Flaesch wrote:
Is there an easy way to convert JSON data containing ASP.NET AJAX Dat
On 2023-04-14 10:44:08 -0700, Adrian Klaver wrote:
> On 4/14/23 9:31 AM, Peter J. Holzer wrote:
> > On 2023-04-13 10:07:09 -0500, Ron wrote:
> > > On 4/13/23 09:44, Sebastien Flaesch wrote:
> > > Is there an easy way to convert JSON data containing ASP.NET AJAX
> > > Dates
> > > into Pos
On 4/14/23 9:31 AM, Peter J. Holzer wrote:
On 2023-04-13 10:07:09 -0500, Ron wrote:
On 4/13/23 09:44, Sebastien Flaesch wrote:
Is there an easy way to convert JSON data containing ASP.NET AJAX Dates
into PostgreSQL timestamp?
I have this kind of JSON data:
{
"Purch
On 2023-04-13 10:07:09 -0500, Ron wrote:
> On 4/13/23 09:44, Sebastien Flaesch wrote:
> Is there an easy way to convert JSON data containing ASP.NET AJAX Dates
> into PostgreSQL timestamp?
>
> I have this kind of JSON data:
>
> {
> "PurchaseOrder" : "45",
>
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 IS
___
From: Ron
Sent: Thursday, April 13, 2023 5:07 PM
To: pgsql-general@lists.postgresql.org
Subject: Re: JSON / ASP.NET AJAX Dates support in PostgreSQL
EXTERNAL: Do not click links or open attachments if you do not recognize the
sender.
On 4/13/23 09:44, Sebastien Flaesch wro
On 4/13/23 09:44, Sebastien Flaesch wrote:
Hello,
Is there an easy way to convert JSON data containing ASP.NET AJAX Dates
into PostgreSQL timestamp?
I have this kind of JSON data:
{
"PurchaseOrder" : "45",
"CreationDate" : "\/Date(167235840)\/",
"LastChangeDateTime" :
Hello,
Is there an easy way to convert JSON data containing ASP.NET AJAX Dates into
PostgreSQL timestamp?
I have this kind of JSON data:
{
"PurchaseOrder" : "45",
"CreationDate" : "\/Date(167235840)\/",
"LastChangeDateTime" : "\/Date(1672692813062+0100)\/"
}
Warning: No
