Hello,
Sorry for the delay. Are you sure you're using the right SQLDialect? In
your title, you've mentioned that you're using SQLite, but the generated
SQL looks like what is being generated by jOOQ for MySQL, MariaDB. When I
run the query you showed us, I'm getting
where cast(t.dtime as date) = ...
Cheers,
Lukas
2015-05-15 4:42 GMT+02:00 ChengYi Lin <[email protected]>:
> Hi
>
> I want to cast timestamp to date.
> c.selectDistinct(t.ID).from(t).where(DSL.date(t.DTIME).eq(date))
>
> The generated sql gets empty result:
> where cast(User.dtime as date) = '2015-03-01'
>
> 'date function' gets expected answer:
> where date(User.dtime) = '2015-03-01'
>
> Should it generate the 'date function'? Thanks.
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
