Create a C#/.Net json date in php

Question

How can I create a date string in PHP that can be read by .NET's non standard date format:

eg Given this PHP code:

$fetch = mysql_query("SELECT birthday FROM people"); 
while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
    $birthday = $row['birthday'];
    $json = ??? // some way to convert it to the .net json format
}

How can I manipulate that PHP date to return this style of JSON as expected by C#/.Net's json deserialize method:

{"birthday":"\/Date(1331550000000)\/"}

CorbinUX · Accepted Answer · 2012-12-03 19:58:51Z

3

The .NET format is Milliseconds from the Epoch - so the following format worked for me

 $date = '/Date('.(date("U",time())*1000).'-0500)/';

answered Dec 3, 2012 at 19:58

CorbinUX

5867 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

xdazz · Accepted Answer · 2012-07-03 01:48:31Z

0

.Net's json deserialize method can accept any json data. You could build the json like below.

$fetch = mysql_query("SELECT birthday FROM people"); 
$birthdays = array();
while ($row = mysql_fetch_array($fetch, MYSQL_ASSOC)) {
    $birthdays[] = $row;
}
$json = json_encode($birthdays);
echo $json;

answered Jul 3, 2012 at 1:48

xdazz

161k38 gold badges255 silver badges278 bronze badges

4 Comments

JK. Over a year ago

Unfortunately the remote server I am connecting to will only accept one exact date format: \/Date(1331550000000)\/ and throws an exception if any other format is sent.

xdazz Over a year ago

@JK What is your birthday like?

JK. Over a year ago

Lol, thats a bit personal isnt it, I hardly know you :) (Its a standard mysql datetime column)

xdazz Over a year ago

@JK SO you want to turn date to a timestamp? But you should know you should not use timestamp to present birthday.

Collectives™ on Stack Overflow

Create a C#/.Net json date in php

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related