Hello all, does Derby TIMESTAMP data type support millisecond? In reference manual ( http://db.apache.org/derby/docs/10.8/ref/rrefsqlj27620.html) is stated:
*yyy-mm-dd hh:mm:ss[.nnnnnn] yyyy-mm-dd-hh.mm.ss[.nnnnnn]* *The first of the two formats above is the java.sql.Timestamp format.* *The year must always have four digits. Months, days, and hours may have one or two digits. Minutes and seconds must have two digits. Nanoseconds, if present, may have between one and six digits.* However because 1 millisecond = 1 000 000 nanoseconds even 1 millisecond can't be stored because it has 7 digis (max is 6)... Also, IMHO because 1 second = 1 000 000 000 nanoseconds, so nanosecond part should have 9 digits, not 6. Also, http://docs.oracle.com/javase/7/docs/api/java/sql/Timestamp.html#setNanos(int)expect that nano part will have max 9 digits. Thanks for your comments. -- Hezky den / Have a nice day Libor JELÍNEK VIRTAGE SOFTWARE // software - design - web Lucni 542 // 285 04 Uhlirske Janovice // Czech Republic support: +420 315 555 488 // cell: +420 777 205 142 email/jabber: [email protected] // web: www.virtage.com Visit our developer adventures at http://devblog.virtage.com!
