Is there a way to format grid data?

Yes, you can format your grid data by clicking on the small circle in the column header. From there you will be presented with various formatting options, such as date formatting, number formatting and conditional formatting.

Here is an example of date formatting: http://recordit.co/dgwJPd5dH3

You can also format your dates using Cloud9QL directly. Here's an example of widget level: http://recordit.co/3Isga7wdcn