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

5 votes291 views1 answer
Mysql created at yesterdau
SQL
0 vote277 views1 answer
Mysql remove tabs from string
SQL
3 votes272 views4 answers
Mysql delete duplicate rows
SQL
0 vote279 views1 answer
Mysql find missing values
SQL
0 vote305 views1 answer
How to join result table in mysql
SQL
22 votes281 views4 answers
Show list of users in mysql
SQL
2 votes307 views1 answer
Ifnull postgres
SQL
1 vote304 views1 answer
Epoch time converter in snowflake
SQL
0 vote301 views1 answer
Create table database in psql
SQL
0 vote347 views1 answer
Mysl like insert a variable
SQL