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

13 votes232 views2 answers
Get date from now() mysql
SQL
1 vote244 views1 answer
Vagrant mysql downgrade version
SQL
0 vote234 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote218 views1 answer
What is mysql_pconnect
SQL
0 vote229 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote228 views1 answer
Add computed column to table sql server
SQL
12 votes207 views4 answers
SQL Where
SQL
2 votes251 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote223 views1 answer
Oracle grant on all tables in schema
SQL
3 votes241 views1 answer
Only join in sql
SQL