/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 vote195 views1 answer
Sql server list table sizes
SQL
0 vote173 views1 answer
Double in sql server example
SQL
13 votes174 views6 answers
Mysql update from select
SQL
0 vote191 views3 answers
How to run sql query
SQL
0 vote167 views1 answer
How to remove default in mysql
SQL
0 vote220 views1 answer
Postgres list all triggers
SQL
0 vote186 views1 answer
Postgres declare variable
SQL
1 vote172 views1 answer
How to truncate a table in databse
SQL
0 vote157 views1 answer
Postgresql inline table
SQL
1 vote186 views1 answer
Postgres power
SQL