diff options
Diffstat (limited to 'Bugzilla/DB')
-rw-r--r-- | Bugzilla/DB/Mysql.pm | 6 | ||||
-rw-r--r-- | Bugzilla/DB/Pg.pm | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/Bugzilla/DB/Mysql.pm b/Bugzilla/DB/Mysql.pm index 71bb97588..c006e5fd0 100644 --- a/Bugzilla/DB/Mysql.pm +++ b/Bugzilla/DB/Mysql.pm @@ -133,6 +133,12 @@ sub sql_istring { return $string; } +sub sql_from_days { + my ($self, $days) = @_; + + return "FROM_DAYS($days)"; +} + sub sql_to_days { my ($self, $date) = @_; diff --git a/Bugzilla/DB/Pg.pm b/Bugzilla/DB/Pg.pm index 4424e65fd..a8f54f903 100644 --- a/Bugzilla/DB/Pg.pm +++ b/Bugzilla/DB/Pg.pm @@ -111,6 +111,12 @@ sub sql_limit { } } +sub sql_from_days { + my ($self, $days) = @_; + + return "TO_TIMESTAMP(${days}::int, 'J')::date"; +} + sub sql_to_days { my ($self, $date) = @_; |