Supporting nanoseconds resolution in an insertion

[Nirmal Fernando]

Hi All,

While referring to DateTimeTest I found the following test case [1].
I think we should allow up to nanoseconds, but I am wondering whether
it's not the ISO format.

Is it ok to change this test case?

A help is highly appreciated.

Thanks.

[1]
/**
     *  Don't allow more than microseconds in ISO format: cloudscape
rejects.
     */
    public void testISOFormat_MoreThanMicroseconds() throws SQLException{
        Statement st = createStatement();

        assertStatementError("22007", st, "insert into ts (ts1) values "
                + "('2003-03-05-17.05.43.999999999')");

        assertStatementError("22007", st, " insert into ts (ts1) values "
                + "('2003-03-05-17.05.43.999999000')");

        st.close();
    }
-- 
Best Regards,
Nirmal

C.S.Nirmal J. Fernando
Department of Computer Science & Engineering,
Faculty of Engineering,
University of Moratuwa,
Sri Lanka.