Sure. That's up to you to decide, whether you can live with that. I'm used to systems that are synchronised to the precision of some fractional seconds, so it never occurred to me :-)
2012/4/2 Ian Clarke <[email protected]>: > Right, although won't that have the disadvantage that there will be > incorrect behavior if the clock in the DB is different to the clock on the > local machine? > > Ian. > > > On Mon, Apr 2, 2012 at 1:40 AM, Lukas Eder <[email protected]> wrote: >> >> Yes, that looks reasonable. Of course, if that's what you want to do >> (now+1 hour), you could also do it in Java: >> >> Calendar cal = Calendar.getInstance(); >> cal.add(Calendar.HOUR_OF_DAY, 1); >> Timestamp t = new Timestamp(cal.getTimeInMillis()); >> >> Cheers >> Lukas >> >> >> 2012/4/2 Ian Clarke <[email protected]> >>> >>> Ah, quick question. I could be misinterpreting, but this appears to be >>> adding 1 hour to the current value of the NEXT_POLL_AFTER field, but >>> actually I'd like to set it to an hour after the current timestamp. Am I >>> correct in assuming this is how to do >>> this: https://gist.github.com/25672655213bee12bb8c >>> >>> Thanks again! >>> >>> Ian. >>> >>> On Sunday, April 1, 2012 1:54:10 AM UTC-5, Lukas Eder wrote: >>>> >>>> Hello Ian, >>>> >>>> I'm about to standardise date/time arithmetic for jOOQ 2.2.0. This >>>> area is quite complex, as hardly any database follows the SQL standard >>>> for date/time intervals. In the mean time, I suggest you use >>>> MySQL-specific date/time functions, as specified here: >>>> >>>> http://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_date-add >>>> >>>> i.e. >>>> create >>>> .update(RSS_DESTINATION_SOURCES) >>>> .set(NEXT_POLL_AFTER, >>>> // Create a plain SQL function for adding dates >>>> function("date_add", Timestamp.class, NEXT_POLL_AFTER, >>>> // Add a MySQL-specific interval literal to your date >>>> literal("interval 1 hour"))); >>>> >>>> Cheers >>>> Lukas >>>> >>>> 2012/3/31 Ian Clarke <[email protected]>: >>>> > A quick question: >>>> > >>>> > How would I update a field (a MySql timestamp) to the current time >>>> > plus 1 >>>> > hour? >>>> > >>>> > ie. >>>> > >>>> > create.update(Tables.RSS_DESTINATION_SOURCES) >>>> > .set(RssDestinationSources.NEXT_POLL_AFTER, ??? ) >>>> > >>>> > Thanks, >>>> > >>>> > Ian. >>>> > >>>> > -- >>>> > Ian Clarke >>>> > Blog: http://blog.locut.us/ >>>> > >> >> > > > > -- > Ian Clarke > Blog: http://blog.locut.us/ >
