How do you apply formating to fields? IE DATE_FORMAT

[mrkcmo]

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?