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.