Hello everyone,
I would like to make a SQL query but it seems that some sql functions are not supported by flipabit. Could someone tell my what kind of sql functions are supported ?
Here is my query :
SELECT *, “color1.png” color FROM data WHERE “Repetition” = “Weekly” AND “Days” LIKE DAYNAME()
Thats for an icon that must be displayed only some days of the week. So in my database I have a “Days” field that contents all the days the icon must be displayed.
But it seems that DAYNAME() doesn’t work with flipabit… Same goes for MONTH() or YEAR(). That’s strange because the function DATE() is supported, by example. How can I do then ?
Thanks by advance