diff options
| author | mkanat%kerio.com <> | 2005-03-03 16:19:09 +0100 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-03-03 16:19:09 +0100 |
| commit | 7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba (patch) | |
| tree | e509aee1bc024c0d486e557cd3f7a2e9750f45e8 /Bugzilla/Search.pm | |
| parent | 0e8f16e1c64b07cf6d90264f8f754307d340b30e (diff) | |
| download | bugzilla-7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba.tar.gz bugzilla-7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba.tar.xz | |
Bug: 284244: DATE_SUB and DATE_ADD are not ANSI SQL
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=wicked, a=justdave
Diffstat (limited to 'Bugzilla/Search.pm')
| -rw-r--r-- | Bugzilla/Search.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index f2e630784..1a0cb9a7f 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -922,7 +922,7 @@ sub init { } elsif ($unit eq 'y') { $unitinterval = 'YEAR'; } - my $cutoff = "DATE_SUB(NOW(), " . + my $cutoff = "NOW() - " . $dbh->sql_interval("$quantity $unitinterval"); my $assigned_fieldid = &::GetFieldID('assigned_to'); push(@supptables, "LEFT JOIN longdescs comment_$table " . |