Changeset 809 for branches/0.4/web

Timestamp:

04/08/13 21:20:13 (11 years ago)

Author:

ramonb

Message:

• cast timestamp to int for operator

File:

• branches/0.4/web/addons/job_monarch/libtoga.php (modified) (1 diff)

branches/0.4/web/addons/job_monarch/libtoga.php

@@ -238 +238 @@
             if( $start_from_time )
             {
-                $query_args[] = "job_start_timestamp >= $start_from_time";
+                $query_args[] = "CAST(job_start_timestamp as INT) >= $start_from_time";
             }
             if( $start_to_time )
             {
-                $query_args[] = "job_start_timestamp <= $start_to_time";
+                $query_args[] = "CAST(job_start_timestamp as INT) <= $start_to_time";
             }
             if( $end_from_time )
             {
-                $query_args[] = "job_stop_timestamp >= $end_from_time";
+                $query_args[] = "CAST(job_stop_timestamp as INT) >= $end_from_time";
             }
             if( $end_to_time )
             {
-                $query_args[] = "job_stop_timestamp <= $end_to_time";
+                $query_args[] = "CAST(job_stop_timestamp as INT) <= $end_to_time";
             }