API returning invalid Date in PHP

Question

I am using an API in my code and the Date i get is something like this

"DateOfBirth":Date(-2208960000000-0800)

I am using Curl in my php code, If I try the API in fiddler or any REST client I get correct date like 22-3-2010, I thought that 2208960000000 could be unix timestamp, but seems very odd that how in REST client the response is different and totally different when I use in PHP code,

EDIT: The response from API is XML but I am using "Content-type: application/json" in my CURL, I then use json_Encode() and can easily traverse through API, I think when I get the data by JSON it sends me this "DateOfBirth":Date(-2208960000000-0800) Any help in this regard?

Thank you

Can you show the code that you're using to generate / parse the date? — newfurniturey, Jun 13 '14 at 12:57
That looks almost like a JSON date from .NET. See http://stackoverflow.com/questions/10286204/the-right-json-date-format. Unfortunately, PHP's `json_decode()` doesn't recognize it. — Barmar, Jun 13 '14 at 13:02
@newfurniturey the date is generated through the API, I am just getting data from the API — user3680538, Jun 13 '14 at 13:12
Do you use 32 bit software (on 32 bit system) ? Looks like some kind of overflow, keep in mind JS time's are in milliseconds rather than seconds. — Daniel W., Jun 13 '14 at 13:30

score 0 · Accepted Answer · answered Jun 13 '14 at 12:58

0

Try this :

 var isWcfJsonDate = /\/Date(.*)\//.test("Your Date String");
        if (isWcfJsonDate)
        {
                dateStr = dateStr.match(/Date\((.*?)\)/)[1];
                dateValue = new Date(parseInt(dateStr));
                return dateValue;
        }
        dateValue = new Date(dateObject);
        console.log( dateValue); //Use your date value

answered Jun 13 '14 at 12:58

Rajarshi Goswami

356
1
9

@rm-rf it's transformed json (form xml), did no one read the question? – Daniel W. Jun 13 '14 at 13:27
1

OK, a little search gave me this: http://stackoverflow.com/questions/16749778/php-date-format-date1365004652303-0500 – h.s.o.b.s Jun 13 '14 at 13:32
Yeah its js, just I was trying on fiddler so this worked – Rajarshi Goswami Jun 13 '14 at 13:33
As Dan and rm -rf said, it has to be converted to the required formt, something like the above link by @rm -rf posted should work – Rajarshi Goswami Jun 13 '14 at 13:36

API returning invalid Date in PHP

1 Answers1