/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

3 votes98 views1 answer
Oracle APEX elapsed time
SQL
4 votes115 views1 answer
W3schools create table
SQL
0 vote99 views2 answers
Sql day from datetime
SQL
2 votes100 views1 answer
Mysql increment value by 1 in update
SQL
0 vote103 views3 answers
Above average salary in sql
SQL
0 vote161 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote105 views1 answer
How to get inserted id in sql server
SQL
0 vote108 views1 answer
Template MySQL Zabbix agent
SQL
4 votes98 views1 answer
Mysql set max connections
SQL
2 votes58 views2 answers
Mysql get last character of string
SQL