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

1 vote344 views1 answer
Oracle see column type
SQL
2 votes313 views1 answer
How to insert string variable into sqlite database
SQL
0 vote290 views1 answer
Replace sqlalchemy
SQL
15 votes320 views4 answers
Export mysql db using command line
SQL
1 vote263 views2 answers
Show sql logs in spring boot
SQL
5 votes315 views1 answer
Oracle sysdate - 1 month
SQL
0 vote305 views1 answer
Sql show all users
SQL
0 vote347 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote287 views2 answers
Mysql slave status
SQL
0 vote300 views1 answer
How to check even or odd in sql
SQL