Closed (fixed)
Project:
Forena Reports
Version:
6.x-2.x-dev
Component:
Documentation
Priority:
Normal
Category:
Support request
Assigned:
Unassigned
Reporter:
Created:
15 Jul 2011 at 19:30 UTC
Updated:
27 Apr 2013 at 15:59 UTC
just a note for others that may happen to experience similar troubles ... i guess there is not much to do about it , except not using the drupal repo, which i personally find handy.
in my sql i had date formatting in the form : date_format(date,'%d.%m'). I was a little suprised that all my dates were on the 0th day :) It turned out that apparently db_query made the %d into a 0 ...
Comments
Comment #1
metzlerd commentedTry doubling the % per this comment:
http://api.drupal.org/api/drupal/includes--database.pgsql.inc/function/d...
It might work....
Comment #2
metzlerd commentedClosing this... assuming this syntax works.