/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

1 vote222 views2 answers
How to drop a unique constraint in sql
SQL
0 vote293 views1 answer
ALV GRID events
SQL
0 vote235 views1 answer
Oracle SQL join three tables and group by column
SQL
1 vote238 views1 answer
Load mysql dumb
SQL
3 votes250 views2 answers
Oracle privileges users
SQL
0 vote250 views1 answer
Sparql if bound query
SQL
39 votes249 views5 answers
Sql drop column
SQL
0 vote262 views1 answer
Mysql reset wp_options
SQL
20 votes243 views3 answers
SQL query rename table
SQL
0 vote310 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL