Display datetime as text?
geowil11
Member, PRO Posts: 5
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