-
|
I am making a simple statement that compares created at to a timestamp. import (
"github.com/go-jet/jet/v2/sqlite"
. "github.com/intaek-h/part-time-mothers/.gen/table"
)
// I want to get all the rows that have CreatedAt smaller than "2021-01-01"
JobPostings.CreatedAt.LT(sqlite.TIMESTAMP(sqlite.String("2021-01-01 00:00:00"))),Jet is giving me this error saying please help me |
Beta Was this translation helpful? Give feedback.
Answered by
houten11
May 1, 2024
Replies: 1 comment 1 reply
-
|
Use JobPostings.CreatedAt.LT(sqlite.DATETIME("2021-01-01 00:00:00")),
|
Beta Was this translation helpful? Give feedback.
1 reply
-
|
@houten11 thank you it worked! |
Beta Was this translation helpful? Give feedback.
Answer selected by
intaek-h
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Use
DATETIME, sqlite doesn't supportTIMESTAMP.TIMESTAMPshouldn't be exposed for sqlite. It is probably a bug.