Perfect, thank you Rick! 2012/4/5 Rick Hillegas <[email protected]>
> There's an existing doc issue for this problem: https://issues.apache.org/ > **jira/browse/DERBY-5596<https://issues.apache.org/jira/browse/DERBY-5596> > > Regards, > -Rick > > > On 4/5/12 7:28 AM, Rick Hillegas wrote: > >> Hi Libor, >> >> The reference manual needs to be corrected. Derby supports 9 nanosecond >> digits. See the following script output: >> >> ij> connect 'jdbc:derby:memory:db;create=**true'; >> ij> create table t( a timestamp ); >> 0 rows inserted/updated/deleted >> ij> insert into t( a ) values ( timestamp( '2012-04-05 07:16:19.123' ) ); >> 1 row inserted/updated/deleted >> ij> insert into t( a ) values ( timestamp( '2012-04-05 07:16:19.123456' ) >> ); >> 1 row inserted/updated/deleted >> ij> insert into t( a ) values ( timestamp( '2012-04-05 >> 07:16:19.123456789' ) ); >> 1 row inserted/updated/deleted >> ij> select * from t; >> A >> ----------------------------- >> 2012-04-05 07:16:19.123 >> 2012-04-05 07:16:19.123456 >> 2012-04-05 07:16:19.123456789 >> >> 3 rows selected >> >> Hope this helps, >> -Rick >> >> On 4/5/12 6:16 AM, Libor Jelinek wrote: >> >>> Hello all, >>> does Derby TIMESTAMP data type support millisecond? In reference manual ( >>> http://db.apache.org/derby/**docs/10.8/ref/rrefsqlj27620.**html<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)<http://docs.oracle.com/javase/7/docs/api/java/sql/Timestamp.html#setNanos(int)>< >>> http://docs.oracle.com/**javase/7/docs/api/java/sql/** >>> Timestamp.html#setNanos%28int%**29<http://docs.oracle.com/javase/7/docs/api/java/sql/Timestamp.html#setNanos%28int%29>> >>> 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] <mailto:[email protected]> // >>> web: www.virtage.com <http://www.virtage.com> >>> >>> Visit our developer adventures at http://devblog.virtage.com! >>> >>> >> >> >
