How to isolate the day, month and year from a date

If you wish to isolate the day, month and year portion of a date, then use Cloud9QL date_format.

For example:

For field X that contains 01/07/2003

date_format(X,mmm) would give you the month number 07 (as a string)