From 305d4c05dcde2b7003d822dded3a13a7bbab046f Mon Sep 17 00:00:00 2001
From: Jerome Sautret <jerome.sautret@process-one.net>
Date: Mon, 10 Oct 2016 11:32:36 +0200
Subject: [PATCH] Fix delete_old_messages command for SQL backends

---
 src/mod_offline_sql.erl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/mod_offline_sql.erl b/src/mod_offline_sql.erl
index feefd3dd0..d9de50e04 100644
--- a/src/mod_offline_sql.erl
+++ b/src/mod_offline_sql.erl
@@ -81,7 +81,7 @@ remove_old_messages(Days, LServer) ->
 		 [<<"DELETE FROM spool"
 		   " WHERE created_at < "
 		   "NOW() - INTERVAL '">>,
-		  integer_to_list(Days), <<"';">>]) of
+		  integer_to_list(Days), <<"' DAY;">>]) of
 	{updated, N} ->
 	    ?INFO_MSG("~p message(s) deleted from offline spool", [N]);
 	_Error ->
-- 
2.50.1