/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

2 votes209 views2 answers
Postgres add column integer
SQL
2 votes207 views2 answers
Postgres trigger insert into another table
SQL
0 vote202 views1 answer
Rename view mysql
SQL
2 votes198 views2 answers
Created at and updated at in mysql
SQL
4 votes213 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
11 votes224 views1 answer
Ddl view
SQL
0 vote202 views1 answer
Laravel migration sql dump
SQL
0 vote214 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote199 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote206 views1 answer
Consulta alias con inner join
SQL