Displaying 1 result from an estimated 1 matches for "elapsedtime_sec".
2006 Jul 25
2
Losing precision while copying interval type data (Postgres)
....
Here is what I did:
@newData.elapsedtime = @oldData.elapsedtime
@newData.save
Result:
both displayed as 00:00:02.453 in the table, however, if I use the
following command to convert its value into float
( SELECT date_part(''epoch''::text, [table].elapsedtime) AS date_part) AS
elapsedtime_sec
The original --> 2.4529983024597
After copy --> 2.453
Is there any way to keep the original value?
Thank you very much!
--
Posted via http://www.ruby-forum.com/.