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

3 votes332 views3 answers
How to add month in update sql
SQL
5 votes384 views1 answer
Oracle drop index if exists
SQL
0 vote323 views2 answers
Oracle create chain rule
SQL
0 vote337 views1 answer
Sql count matching group by
SQL
3 votes326 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
1 vote370 views3 answers
How to reset id column in sql server
SQL
0 vote341 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote332 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote371 views1 answer
Copy row from db to db mysql
SQL
2 votes343 views2 answers
Mysql add hours to time field
SQL