/SQL/Oracle current timestamp insert statement

Oracle current timestamp insert statement

--if you want to hardcode the time stamp: 

insert
into tablename (timestamp_value)
values (TO_TIMESTAMP(:ts_val, 'YYYY-MM-DD HH24:MI:SS'));

--if you want the current time stamp to be inserted then:

insert
into tablename (timestamp_value)
values (CURRENT_TIMESTAMP);

Source: stackoverflow.com

Similar codes

0 vote113 views4 answers
Mysql on kubernetes
SQL
0 vote120 views1 answer
Sql include rows with 0 values
SQL
0 vote116 views1 answer
Postegresql update to null
SQL
0 vote122 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote68 views1 answer
Oracle last user logon
SQL
2 votes129 views1 answer
Wait delay in sql server
SQL
0 vote110 views1 answer
How to drop a trigger in postgresql
SQL
0 vote127 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote121 views2 answers
Mysql select date from datetime
SQL
1 vote115 views1 answer
Oracle duration between timestamps
SQL