Re: Loss of precision using TIMESTAMP with Oracle

2003-07-07 Thread Danilo Tommasina
hi nicolas, yep, Oracle doesn't store millis in TIMESTAMP personally I just use a NUMBER field and store the millis time generated by Java (System.currentTimeMillis() or date.getTime() where date is an instance of java.util.Date). doing this you will not be able to read the timestamp directly fo

Loss of precision using TIMESTAMP with Oracle

2003-07-07 Thread Nicolas Girard
Hi, I'm scared to death since i discovered that the timestamp i stored have lost their millisecond informations... I've found the following page, describing an ugly workaround which uses code specific to Oracle: http://weblogs.flamefew.net/bayard/archives/000114.html Could someone help me to dea