fix time zones

1 files changed, 5 insertions, 5 deletions

diff --git a/internal/queries/queries.sql.go b/internal/queries/queries.sql.go
index 35d90ea..0a7d134 100644
--- a/internal/queries/queries.sql.go
+++ b/internal/queries/queries.sql.go
@@ -595,8 +595,8 @@ select
 from time_entry te
 join client c on te.client_id = c.id
 left join project p on te.project_id = p.id
-where date(te.start_time) >= date('now', 'start of month')
-    and date(te.start_time) <= date('now')
+where date(te.start_time, 'localtime') >= date('now', 'localtime', 'start of month')
+    and date(te.start_time) <= date('now', 'utc')
 group by p.id, p.name, c.id, c.name
 order by c.name, p.name
 `
@@ -918,7 +918,7 @@ select
         end
     ) as integer) as total_seconds
 from time_entry te
-where date(te.start_time) = date('now')
+where date(te.start_time, 'localtime') = date('now', 'localtime')
 `
 
 func (q *Queries) GetTodaySummary(ctx context.Context) (int64, error) {
@@ -945,8 +945,8 @@ select
 from time_entry te
 join client c on te.client_id = c.id
 left join project p on te.project_id = p.id
-where date(te.start_time) >= date('now', 'weekday 1', '-6 days')
-    and date(te.start_time) <= date('now')
+where date(te.start_time, 'localtime') >= date('now', 'localtime', 'weekday 0', '-6 days')
+    and date(te.start_time) <= date('now', 'utc')
 group by p.id, p.name, c.id, c.name
 order by c.name, p.name
 `