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

19 votes205 views5 answers
Change column name mysql command line
SQL
0 vote203 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote211 views1 answer
Mysql export search results
SQL
23 votes207 views1 answer
How remove column in mysql
SQL
1 vote183 views1 answer
Minus vs intersect in sql
SQL
0 vote221 views1 answer
Insert or update sql firebird
SQL
0 vote203 views1 answer
Sql common columns
SQL
0 vote184 views1 answer
Sql query with date
SQL
1 vote197 views1 answer
Oracle grant on all tables in schema
SQL
2 votes209 views1 answer
Oracle list grants on package
SQL