PQL format()

PQL FORMAT Function
The FORMAT function is used to format how a field is to be displayed.

PQL FORMAT Example
We have the following "Cupcakes" stable:

Now we want to display the cupcakes and prices per today's date (with today's date displayed in the following format "YYYY-MM-DD").

We use the following SELECT statement:

The result-set will look like this: