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 vote141 views1 answer
Sqlalchemy on delete set null
SQL
0 vote114 views1 answer
Oracle 11g forget password
SQL
0 vote135 views1 answer
How to login to mysql in homestead
SQL
0 vote122 views2 answers
How to set global time_zone in mysql
SQL
1 vote121 views1 answer
Delete triger pl pg sql
SQL
6 votes140 views1 answer
Oracle rank
SQL
0 vote139 views1 answer
Sql server list table sizes
SQL
2 votes125 views2 answers
Mysql on duplicate key ignore
SQL
0 vote128 views1 answer
Postgresql remove new line from string
SQL
11 votes145 views2 answers
Having keyword sql
SQL