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 vote133 views1 answer
Calculate age in sql
SQL
0 vote128 views1 answer
Postgresql alter column nullable
SQL
0 vote134 views1 answer
Mysql multiple primary keys
SQL
1 vote136 views1 answer
SQL: merging multiple row data in string
SQL
3 votes131 views2 answers
Mysql time
SQL
4 votes146 views1 answer
T-sql get duplicate rows
SQL
0 vote217 views1 answer
Install ms sql server management studio
SQL
0 vote136 views1 answer
Select row from mysql where date more than 30 days
SQL
11 votes142 views2 answers
How to import mysql database command line
SQL
0 vote121 views1 answer
Get records in sql according to month name and count
SQL