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

0 vote131 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote123 views1 answer
Compress sql file database ubuntu
SQL
3 votes115 views1 answer
Laravel paginate raw sql
SQL
3 votes119 views1 answer
Get current month last date in sql server
SQL
1 vote129 views1 answer
Drop primary key oracle
SQL
4 votes121 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote121 views1 answer
Sql values that contains certain multiple ids
SQL
1 vote114 views1 answer
ORA-01950
SQL
12 votes133 views1 answer
Run mysql instance in docker
SQL
8 votes106 views1 answer
Ltrim sql
SQL