Support every timestamp field

A feature patch or sponsoring is welcome.

That patch illustrates the concept. It does not work in any sensible way though (for me at least?).
Did you try Krumo (devel module) on the hook data? There is no key 'is date' anywhere.
Also your scope is to broad. You'll catch fields like Feeds import date, and file upload dates. Then the custom fields definitions are one level deeper afaik.

Thanks for sketching the idea though!

Ok. Let's keep it around as 'Needs Review' and get some comments on it.

The problem could be on my end. I do see the 'is date'-key in the Date module, but it doesn't show up in the hook data. Maybe an issue with module ordering.

Do you get the functionality on 'created' and 'changed' fields? Those are not from the Date module and don't have 'is date'. Does Date override something there for you?

Thanks.

Yes date_views module add a "is date" to all date fields in date_views_views_data_alter().

Thanks webflo, I didn't enable the date views module here:)
Bago, option 2 looks fine and works.
I'm still concerned about the scope. This walks across all modules and tables. do we really want all these?

comment created
comment changed
feeds_item imported
feeds_log log_time
feeds_log request_time
node created
node changed
node_revision timestamp
file_managed timestamp
users created
users access
users login

(Feeds is the only non-core here as an example).
It might be nice to have it on all core fields, and it's opt-in after all... Thoughts?

Strangely enough my Date-module fields are marked with views_handler_field_field not views_handler_field_date. Once I figure that out this patch gets released. Thanks again!

patch #2 works fine for me, I can now SQL-format commerce entity fields. Probably it should also patch the .info file to list date_views as a dependency.

@JurriaanRoelofs can you try patch #8?
Also note that this module works without the Date module (for Created & Changed fields). So Date or Date_views are not a dependency.

Jurriaan - does this work for Commerce order date fields? I've applied patch #2 however no checkbox shows up on my order date field settings.

Managed to get it showing, all working great for aggregation apart from the fact that it doesn't seem to sort by date. Adding a date sorting rule stops the aggregation from working.

See attached for without the date sorting, the months are in random places.

For some reason adding MIn or Max to the aggregation settings for date field in sort criteria managed to get this in the right order.

I dont use min and max. I'll try to make time for this tomorrow.

Cool - seems to be working fine for me at present with the Min & Max, no idea why though!

Sorry for the slow reply. I just tested patch #8 and it works fine too.

hm. I did not get it on date field of a content type. date views module is enabled.

I tried one of the core fields and it works.

how can i figure out the problem? and how can I get it work?

@bennos did you use the new 3.1 version? If you know php you can use the devel module and dpm() to inspect the data structure in the hook. http://drupalcode.org/project/views_date_format_sql.git/blob/HEAD:/views...

It works on core fields ok, but I'm trying to apply to a date field in a field collection entity and doesn't work.
Any help?
Thanks

I like to use this also for date fields created by myself, not just for the core dates like node.changed, node.created and so on.

Please can anybody help me?

I tried do make a new class:

class views_date_format_sql_handler_field_MYDATEFIELDS extends views_handler_field_field {
same code
}

I remove this code:

 &&
         ($field['field']['handler'] == 'views_handler_field_date')

from the function views_date_format_sql_views_data_alter(&$data) .

Now i have the checkbox "Use SQL to format date" at my date fields, but it doesn't work.

Edit:
I got these errors:

Error message
Notice: Undefined index: date_format in views_date_format_sql_handler_field_date->query() (line 38 of
modules/views_date_format_sql/includes/views_date_format_sql_handler_field_date.inc)
Notice: Undefined index: custom_date_format in views_date_format_sql_handler_field_date->query() (line 39 of
modules/views_date_format_sql/includes/views_date_format_sql_handler_field_date.inc)

Thx for helping me.

Please do not comment on closed issues. Open a support request ticket. Give more detail: what modules did you enable what exactly is the setup.