Digest for jooq-user@googlegroups.com - 1 update in 1 topic

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Digest for jooq-user@googlegroups.com - 1 update in 1 topic

http://groups.google.com/group/jooq-user/topics mailing list
Samir Faci <[hidden email]>: Sep 27 11:11AM -0700

Somewhat of a follow up to a dated post.
 
I'm trying to use Jooq Intervals with postgres. Is there a better pattern
to use besides this one:
 
 
.where(TPAS.INTEGRATION_LOG.EXECUTION_DATE.eq(field(“current_date -
interval ‘1 days’“, LocalDateTime.class)))
 
The raw SQL would be:
 
 
log.execution_date::date = current_date - interval '1 days'
 
 
 
 
--
Thank you
Samir Faci
https://keybase.io/csgeek
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to [hidden email].