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 form Oracle, however if you evaluate the timestamp from your app. this won't be a problem. this method of storing dates is independent of the underlying database and allows you to compare dates very fast, however you always have to convert a date in millis before doing any operation of that kind.
bye danilo > 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 deal with this problem, which is blocking for > my experiment ? > > Many thanks in advance, > cheers, > nicolas > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
