/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 vote162 views1 answer
Order by monthly in sql
SQL
0 vote170 views1 answer
Sql server insert inner join
SQL
0 vote167 views1 answer
Psql get table data types
SQL
13 votes174 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
10 votes223 views4 answers
Join multiple tables in sql
SQL
2 votes189 views2 answers
Install postgresql
SQL
0 vote197 views1 answer
Oracle string length
SQL
1 vote181 views1 answer
Moodle query first user access
SQL
1 vote176 views1 answer
Mysql show queries running
SQL
0 vote172 views1 answer
Sequelize postgresql schema
SQL