From ce7373f85c62200fd34f6b827aa04ee156e596e7 Mon Sep 17 00:00:00 2001
From: stronk7 <stronk7>
Date: Mon, 21 Apr 2008 18:10:09 +0000
Subject: [PATCH] Replace custom casting code by proper sql_cast_char2int()
 core function. MDL-12893 ; merged from 19_STABLE

---
 mod/data/field/date/field.class.php | 14 ++------------
 1 file changed, 2 insertions(+), 12 deletions(-)

diff --git a/mod/data/field/date/field.class.php b/mod/data/field/date/field.class.php
index 50236392de..2bf672251c 100755
--- a/mod/data/field/date/field.class.php
+++ b/mod/data/field/date/field.class.php
@@ -113,18 +113,8 @@ class data_field_date extends data_field_base {
     }
 
     function get_sort_sql($fieldname) {
-         global $CFG;
- 
-         switch ($CFG->dbfamily) {
-             case 'postgres':
-             case 'mssql':
-                 return 'CAST('.$fieldname.' AS bigint)';
-             case 'oracle':
-                 return 'TO_NUMBER('.$fieldname.')';
-             case 'mysql':
-             default:
-                 return 'CAST('.$fieldname.' AS signed)';
-         }
+
+         return sql_cast_char2int($fieldname, true);
     }
 
 
-- 
2.39.5