For the reports, I need the Day of the year for a given date.
MySql, SqLite and PostgreSql have different formatting functions regarding this:
For example:
SqLite: strftime( %j, p_person.p_date_of_birth_d)
PostgreSql: to_char(p_person.p_date_of_birth_d, 'DDD')
MySql: DATE_FORMAT(p_person.p_date_of_birth_d, %j)
I suggest to have in the xml files for the report something like this:
DAYOFYEAR(p_person.p_date_of_birth_d)
and in the Database connection files we replace this with the appropriate command.
I think we should document this in the Wiki in the section "Sql compatibility rules"
Any further comments or suggestions on this?
