SQl timestamp code example

Example 1: sql insert timestamp

INSERT INTO TABLE_NAME (TIMESTAMP_VALUE) VALUES (TO_TIMESTAMP('2014-07-02 06:14:00.742000000', 'YYYY-MM-DD HH24:MI:SS.FF'));

Example 2: sql syntax create timestamp column

CREATE TABLE tablename (columnname datetime NOT NULL DEFAULT CURRENT_TIMESTAMP)

Example 3: mysql timestamp format

INSERT INTO ... VALUES ('YYYY-MM-DD HH:MM:SS');