From 1e787858d33e1ffc0463bd1f9f6024cb76a45f13 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 19 Jan 2007 20:29:33 +0000 Subject: [PATCH] hour truncation function fix git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_0@6794 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm b/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm index f0b4e42e1d..05541f21a7 100644 --- a/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm +++ b/Open-ILS/src/perlmods/OpenILS/Reporter/SQLBuilder.pm @@ -728,7 +728,7 @@ package OpenILS::Reporter::SQLBuilder::Column::Transform::hour_trunc; sub toSQL { my $self = shift; - return 'DATE_TRUNC("' . $self->{_relation} . '"."' . $self->name . '")'; + return 'EXTRAC(HOUR FROM "' . $self->{_relation} . '"."' . $self->name . '")'; } sub is_aggregate { return 0 } -- 2.11.0