[tracker/tracker-0.12] SPARQL: Ensure that fn:timezone-from-dateTime returns integer

[Martyn James Russell <mr src gnome org>]

commit 4e873e739abf48426e6817cce7c05b0e010d65e5
Author: JÃrg Billeter <j bitron ch>
Date:   Wed Nov 23 16:58:08 2011 +0100

    SPARQL: Ensure that fn:timezone-from-dateTime returns integer

 src/libtracker-data/tracker-sparql-expression.vala |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)
---
diff --git a/src/libtracker-data/tracker-sparql-expression.vala b/src/libtracker-data/tracker-sparql-expression.vala
index 3aa6597..720cb08 100644
--- a/src/libtracker-data/tracker-sparql-expression.vala
+++ b/src/libtracker-data/tracker-sparql-expression.vala
@@ -632,7 +632,9 @@ class Tracker.Sparql.Expression : Object {
 			sql.append (" * 24 * 3600 + ");
 			sql.append (variable.get_extra_sql_expression ("localTime"));
 			sql.append ("- ");
+			sql.append ("CAST (");
 			sql.append (variable.sql_expression);
+			sql.append (" AS INTEGER)");
 			sql.append (")");
 
 			return PropertyType.INTEGER;