TIMESTAMP

TIMESTAMP stores a combined DATE and TIME value to be stored. It permits a fractional-seconds value of up to nine digits. Derby also supports the ISO format of 23 characters (17 digits, 3 dashes, and 3 decimal points).

Syntax

TIMESTAMP

Corresponding Compile-Time Java Type

java.sql.Timestamp

JDBC Metadata Type (java.sql.Types)

TIMESTAMP

Dates, times, and timestamps cannot be mixed with one another in expressions.

Timestamp only accepts formats accepted by Timestamp.valueOf. Any value that is recognized by the java.sql.Timestamp valueOf(String) method is permitted in a column of the corresponding SQL date/time data type.

Examples

VALUES '1960-01-01 23:03:20'
VALUES TIMESTAMP('1962-09-23 03:23:34.234')
VALUES TIMESTAMP('1960-01-01 23:03:20')