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.
