From 3d20439d49d8b56bf3f12db622a865eb05c1cf39 Mon Sep 17 00:00:00 2001 From: Eric Bollengier Date: Sat, 26 Aug 2006 17:17:12 +0000 Subject: [PATCH] ebl add month/pmonth to STARTTIME_ macros git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@3376 91ce42f0-d328-0410-95d8-f526ca767f89 --- gui/bweb/lib/Bweb.pm | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/gui/bweb/lib/Bweb.pm b/gui/bweb/lib/Bweb.pm index 10a1c1285b..1eb9bd5c35 100644 --- a/gui/bweb/lib/Bweb.pm +++ b/gui/bweb/lib/Bweb.pm @@ -1025,8 +1025,10 @@ our %sql_func = ( MATCH => " ~ ", STARTTIME_DAY => " date_trunc('day', Job.StartTime) ", STARTTIME_HOUR => " date_trunc('hour', Job.StartTime) ", + STARTTIME_MONTH => " date_trunc('month', Job.StartTime) ", STARTTIME_PHOUR=> " date_part('hour', Job.StartTime) ", STARTTIME_PDAY => " date_part('day', Job.StartTime) ", + STARTTIME_PMONTH => " date_part('month', Job.StartTime) ", }, mysql => { UNIX_TIMESTAMP => 'UNIX_TIMESTAMP', @@ -1037,8 +1039,10 @@ our %sql_func = ( MATCH => " REGEXP ", STARTTIME_DAY => " DATE_FORMAT(StartTime, '%Y-%m-%d') ", STARTTIME_HOUR => " DATE_FORMAT(StartTime, '%Y-%m-%d %H') ", + STARTTIME_MONTH => " DATE_FORMAT(StartTime, '%Y-%m') ", STARTTIME_PHOUR=> " DATE_FORMAT(StartTime, '%H') ", STARTTIME_PDAY => " DATE_FORMAT(StartTime, '%d') ", + STARTTIME_PMONTH => " DATE_FORMAT(StartTime, '%m') ", }, ); -- 2.39.5