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 votes131 views1 answer
Sysdate in oracle sql
SQL
0 vote192 views1 answer
Contraint default SQL
SQL
0 vote159 views1 answer
Mysql order by where condition sub query
SQL
0 vote161 views1 answer
Mysql installer no packages found
SQL
4 votes148 views1 answer
Refresh postgres config
SQL
0 vote136 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote146 views1 answer
Where date major today mysql
SQL
4 votes137 views1 answer
Restart for pg_hba.conf file
SQL
5 votes193 views1 answer
Dbms_metadata.get_ddl table
SQL
1 vote143 views1 answer
Rename table column name in mysql
SQL