On Thursday, July 12, 2012 4:01:43 AM UTC-7, Matt Hauck wrote: > > After turning on the prepared statements plugin, I have noticed that my > timestamps are being truncated of their milliseconds when they are saved to > the database (derby), resulting in a loss of accuracy of data that is > rather unfortunate. Is this a known issue? Is there a workaround? Perhaps > to disable prepared statements on these columns?
This is going to be an adapter specific issue. The postgres adapter has specific code to keep the fractional seconds, but not all adapters do. Since you are using derby, this is going to be a jdbc adapter issue. The jdbc adapter has code that is supposed to handle the fractional parts (see set_ps_arg, java_sql_datetime, java_sql_timestamp in lib/sequel/adapters/jdbc.rb). Please post the code you are using and an SQL log. Disabling prepared statements may work around the issue. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/0zzj08jA7ckJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
