fix time zones

2 files changed, 10 insertions, 10 deletions

diff --git a/internal/database/queries.sql b/internal/database/queries.sql
index 969119a..6d1108f 100644
--- a/internal/database/queries.sql
+++ b/internal/database/queries.sql
@@ -82,8 +82,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;
 
@@ -104,8 +104,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;
 
@@ -292,7 +292,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');
 
 -- name: GetRecentTimeEntries :many
 select * from time_entry 
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
 `