From 57222853c90b0ffc4b800adeeddc289d58ee0a25 Mon Sep 17 00:00:00 2001
From: Vitaly Takmazov
Date: Wed, 1 Feb 2023 20:22:05 +0300
Subject: Store timestamp in milliseconds when using SQLite

---
 src/main/java/com/juick/service/EmailServiceImpl.java | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/main/java/com/juick/service/EmailServiceImpl.java')

diff --git a/src/main/java/com/juick/service/EmailServiceImpl.java b/src/main/java/com/juick/service/EmailServiceImpl.java
index 7f358533..85e56a05 100644
--- a/src/main/java/com/juick/service/EmailServiceImpl.java
+++ b/src/main/java/com/juick/service/EmailServiceImpl.java
@@ -119,6 +119,6 @@ public class EmailServiceImpl extends BaseJdbcService implements EmailService {
         Instant day = Instant.now().minus(1, ChronoUnit.DAYS);
         return getNamedParameterJdbcTemplate().update("DELETE FROM auth WHERE ts < :day",
                 new MapSqlParameterSource()
-                        .addValue("day", day.atOffset(ZoneOffset.UTC), Types.TIMESTAMP_WITH_TIMEZONE));
+                        .addValue("day", toDateTime(day.atOffset(ZoneOffset.UTC)), dateTimeType()));
     }
 }
-- 
cgit v1.2.3