diff options
| author | T <t@tjp.lol> | 2025-08-04 10:41:08 -0600 |
|---|---|---|
| committer | T <t@tjp.lol> | 2025-08-04 10:52:51 -0600 |
| commit | 4c29dfee9be26996ce548e2edf0328422df598d0 (patch) | |
| tree | be38e53526f7ddb8e10e9671005b9ecd671a7152 /internal/commands/import.go | |
| parent | 8be5f93f5b2d4b6f438ca84094937a0f7101c59b (diff) | |
Fix time query parameters to force them to datetime format
Diffstat (limited to 'internal/commands/import.go')
| -rw-r--r-- | internal/commands/import.go | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/internal/commands/import.go b/internal/commands/import.go index a767923..a1d0d8f 100644 --- a/internal/commands/import.go +++ b/internal/commands/import.go @@ -186,9 +186,13 @@ func importSingleEntry(q *queries.Queries, entry clockifyEntry, loc *time.Locati projectID = sql.NullInt64{Int64: project.ID, Valid: true} } + // Format times as SQLite-compatible strings for the datetime() function + startTimeStr := startTime.UTC().Format(time.DateTime) + endTimeStr := endTime.UTC().Format(time.DateTime) + _, err = q.CreateTimeEntryWithTimes(context.Background(), queries.CreateTimeEntryWithTimesParams{ - StartTime: startTime.UTC(), - EndTime: sql.NullTime{Time: endTime.UTC(), Valid: true}, + StartTime: startTimeStr, + EndTime: endTimeStr, Description: sql.NullString{String: entry.Description, Valid: entry.Description != ""}, ClientID: client.ID, ProjectID: projectID, |