diff options
Diffstat (limited to 'internal/queries/queries.sql.go')
| -rw-r--r-- | internal/queries/queries.sql.go | 10 |
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 ` |