Ignore:
Timestamp:
04/08/13 21:20:13 (9 years ago)
Author:
ramonb
Message:
  • cast timestamp to int for operator
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/0.4/web/addons/job_monarch/libtoga.php

    r779 r809  
    238238            if( $start_from_time )
    239239            {
    240                 $query_args[] = "job_start_timestamp >= $start_from_time";
     240                $query_args[] = "CAST(job_start_timestamp as INT) >= $start_from_time";
    241241            }
    242242            if( $start_to_time )
    243243            {
    244                 $query_args[] = "job_start_timestamp <= $start_to_time";
     244                $query_args[] = "CAST(job_start_timestamp as INT) <= $start_to_time";
    245245            }
    246246            if( $end_from_time )
    247247            {
    248                 $query_args[] = "job_stop_timestamp >= $end_from_time";
     248                $query_args[] = "CAST(job_stop_timestamp as INT) >= $end_from_time";
    249249            }
    250250            if( $end_to_time )
    251251            {
    252                 $query_args[] = "job_stop_timestamp <= $end_to_time";
     252                $query_args[] = "CAST(job_stop_timestamp as INT) <= $end_to_time";
    253253            }
    254254
Note: See TracChangeset for help on using the changeset viewer.