Hi, so a while back Lukas told me that I could add an hour to a timestamp
and set a field to this value using the following custom MySql code:
.set(RssDestinationSources.NEXT_POLL_AFTER,
// Create a plain SQL function for adding dates
Factory.function("date_add", Timestamp.class,
Factory.currentTimestamp(),
// Add a MySQL-specific interval literal to your date
Factory.literal("interval 1 hour")));
I now see that timestamp arithmetic is supported, but I'm not quite sure
how to do this using it... would you mind clarifying?
Thanks,
Ian.
--
Ian Clarke
Blog: http://blog.locut.us/
