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'));

Source: stackoverflow.com

Sql insert timestamp

INSERT INTO ORDERS VALUES(1,'TO_TIMESTAMP('2022-02-09 07:00:00', 'YYYY-MM-DD HH24:MI:SS'),'OPEN')
INSERT INTO ORDERS VALUES(1,'TO_TIMESTAMP('2022-02-10 08:10:00', 'YYYY-MM-DD HH24:MI:SS'),'READY'); 
INSERT INTO ORDERS VALUES(1,'TO_TIMESTAMP('2022-02-09 09:20:20', 'YYYY-MM-DD HH24:MI:SS'),'CLOSED');

Similar codes

23 votes187 views6 answers
Create table sql server
SQL
0 vote181 views1 answer
Mysql trigger to delete old data
SQL
17 votes183 views4 answers
Mysql remove ubuntu
SQL
0 vote166 views1 answer
Mysql sql select one day before
SQL
0 vote186 views1 answer
Sql statement show all emails with dome
SQL
1 vote175 views1 answer
T-sql disable system versioning
SQL
0 vote176 views1 answer
Oracle merge insert if not exists
SQL
0 vote221 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL
0 vote166 views1 answer
Get null value in sql
SQL
4 votes172 views2 answers
Oracle unlock user
SQL