JOOQ how to get a value from a table record and convert to timestamp

47
September 13, 2017, at 10:20 PM

I have a table with integer values on how often something should occur:

my_table.frequency(Integer)
my_table.last_run(Timestamp)

What I want is to add last run with frequency to check if it is less than or greater than current time.

To do that I figured I should get the frequency value (Integer) and convert it to Timestamp then add last_run and frequency now timestamp using timestamp_add()

I have no luck converting integer to timestamp or adding the two successfully, to later compare to current time.

This has to be done in JOOQ.

This is basically what I'm trying to do.

SELECT * FROM ftp_configurations WHERE ((frequency +  last_run) < CURRENT_TIMESTAMP)

Since the frequency is an integer it is not working out. and to further complicate things it has to be done in jooq.

READ ALSO
hadoop reducer progress 100% but doesn&#39;t end

hadoop reducer progress 100% but doesn't end

I'm running one hadoop job with 16 reduce tasks(hadoop-1

55
JPA inserting header and detail data

JPA inserting header and detail data

I'm new to JPA I want to insert detail data using entitymanagerpersist() here is the header snippet

64
Reduce Google Cloud Endpoints request response header size

Reduce Google Cloud Endpoints request response header size

I'm using a Google Cloud App Engine and Google Cloud Endpoints API for my backend for an Android appThis is all in Java

72
Spring evaluation language (SpEL) not throw exception when accessing invalid key in map

Spring evaluation language (SpEL) not throw exception when accessing invalid key in map

I am new to SpEL and below is a sample workable test that I used for testing

87