TIMESTAMP stores a combined DATE and TIME value to be stored. It permits a fractional-seconds value of up to nine digits.
Dates, times, and timestamps cannot be mixed with one another in expressions.
yyyy-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, if present, must have two digits. Nanoseconds, if present may have between one and six digits.
Derby also accepts strings in the locale specific datetime format, using the locale of the database server. If there is an ambiguity, the built-in formats above take precedence.
VALUES '1960-01-01 23:03:20' VALUES TIMESTAMP('1962-09-23 03:23:34.234') VALUES TIMESTAMP('1960-01-01 23:03:20')