/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

10 votes193 views2 answers
SQL rounding numbers
SQL
0 vote197 views1 answer
Netstat -tln mysql
SQL
11 votes215 views1 answer
Ddl view
SQL
8 votes181 views3 answers
Oracle auto_increment
SQL
0 vote178 views1 answer
Mysql with
SQL
0 vote215 views1 answer
Calculer pourcentage mysql
SQL
0 vote224 views1 answer
Compress sql file database ubuntu
SQL
0 vote249 views1 answer
Oracle plsql sleep
SQL
16 votes206 views2 answers
Sql vs nosql
SQL
0 vote178 views1 answer
Close sql query vb.net
SQL