I store the date and time in a vertex in the form of epoch time, and i wanted to change it to datetime before having to display it.
ListAccum<DATETIME> @lst;
start = {ev};
result = SELECT e from start:e ACCUM e.@lst+=epoch_to_datetime(e.must_start_by),e.@lst+=epoch_to_datetime(e.must_end_by);
PRINT result[result.@lst];
this works when the query is run in interpreted mode and displays the datetime format but when i install the query and run it, it still gives me epoch time.
output when ran in interpretted mode :
{
"result": [
{
"attributes": {
"result.@lst": [
"2022-06-11 02:30:00",
"2022-06-11 06:30:00"
]
},
"v_id": "106505115-1-352868",
"v_type": "event"
}
]
}
output when i run after installing the query:
{
"result": [
{
"attributes": {
"result.@lst": [
1654914600,
1654929000
]
},
"v_id": "106505115-1-352868",
"v_type": "event"
}
]
}
please help me fix this.