GameSalad

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Display datetime as text?

geowil11geowil11 Posts: 5Member, PRO

I am attempting to display a datetime from our database in a display text behavior but for some reason all I am getting out of the table is the year part of the datetime that was passed to GameSalad.

Here is the json that our php is generating when GameSalad is requesting the table:

{"Children":[{"Children":[],"Name":"id225180_headers","Properties":[{"Name":"rowCount","Value":2},{"Name":"columnCount","Value":11},{"Name":"0-1-name","Value":"Player_id"},{"Name":"0-1-type","Value":1},{"Name":"0-2-name","Value":"User_name"},{"Name":"0-2-type","Value":1},{"Name":"0-3-name","Value":"City_id"},{"Name":"0-3-type","Value":1},{"Name":"0-4-name","Value":"Building_id"},{"Name":"0-4-type","Value":2},{"Name":"0-5-name","Value":"Room_id"},{"Name":"0-5-type","Value":2},{"Name":"0-6-name","Value":"Room_time"},{"Name":"0-6-type","Value":"3"},{"Name":"0-7-name","Value":"Item_time"},{"Name":"0-7-type","Value":"3"},{"Name":"0-8-name","Value":"Correct_Answer"},{"Name":"0-8-type","Value":"2"},{"Name":"0-9-name","Value":"Diamonds_amount"},{"Name":"0-9-type","Value":"2"},{"Name":"0-10-name","Value":"Max_Level_Completed"},{"Name":"0-10-type","Value":"2"},{"Name":"0-11-name","Value":"CompletionDate"},{"Name":"0-11-type","Value":"1"}]},{"Children":[],"Name":"id225180","Properties":[{"Name":"1","Value":"2|test|1|1|1|12000|4000|4|0|1|2019-01-01 06:40:20"},{"Name":"2","Value":"2|test|1|1|1|12000|4000|4|0|1|2018-12-29 08:40:20"}]}],"Name":"","Properties":[]}

The value displaying in GameSalad for the first row is 2019 instead of 2019-01-01 06:40:20. Does GameSalad do something weird when importing the json that would cause it to explode the date string on -'s? If so, could changing the display format of the date string work?

Thanks

Sign In or Register to comment.