Open mrkcmo opened 5 years ago
My question is quite simple...I am trying to format a field like the example below:
SELECT id, device_name, DATE_FORMAT(start_time, "%Y, %m, %d, %H, %i, %s") AS start_time, DATE_FORMAT(end_time, "%Y, %m, %d, %H, %i, %s") AS end_time...
I can't seem to find a way to make this work...I have tried: /api/example_table?fields=device,DATE_FORMAT(start_time, "%Y, %m, %d, %H, %i, %s") AS start_time,end_time&_where(start_time, eq,CURDATE())&_size=100...
/api/example_table?fields=device,DATE_FORMAT(start_time, "%Y, %m, %d, %H, %i, %s") AS start_time,end_time&_where(start_time, eq,CURDATE())&_size=100...
This doesn't work thought....any insight?
My question is quite simple...I am trying to format a field like the example below:
SELECT id, device_name, DATE_FORMAT(start_time, "%Y, %m, %d, %H, %i, %s") AS start_time, DATE_FORMAT(end_time, "%Y, %m, %d, %H, %i, %s") AS end_time...I can't seem to find a way to make this work...I have tried:
/api/example_table?fields=device,DATE_FORMAT(start_time, "%Y, %m, %d, %H, %i, %s") AS start_time,end_time&_where(start_time, eq,CURDATE())&_size=100...This doesn't work thought....any insight?