diff options
| -rw-r--r-- | FS/FS/part_event/Condition/day_of_month.pm | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/FS/FS/part_event/Condition/day_of_month.pm b/FS/FS/part_event/Condition/day_of_month.pm index 61cd8d6d1..036cb7066 100644 --- a/FS/FS/part_event/Condition/day_of_month.pm +++ b/FS/FS/part_event/Condition/day_of_month.pm @@ -29,7 +29,11 @@ sub condition_sql { my( $class, $table, %opt ) = @_; my $today = (localtime($opt{'time'}))[3]; my $day = $class->condition_sql_option('day'); - "$today = ANY( string_to_array($day, ',')::integer[] )" + if ($opt{'driver_name'} eq 'Pg') { + "$today = ANY( string_to_array($day, ',')::integer[] )"; + } elsif ( $opt{'driver_name'} eq 'mysql' ) { + "find_in_set($today, $day) > 0"; + } } 1; |