/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 vote180 views1 answer
Firebase sql
SQL
0 vote196 views1 answer
Update view sql
SQL
2 votes288 views1 answer
Oracle list grants on package
SQL
3 votes191 views1 answer
Sql replace character in string in all records
SQL
1 vote189 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
1 vote205 views1 answer
Postgres left join
SQL
2 votes205 views2 answers
How to rename column name in sql server using query
SQL
2 votes150 views1 answer
Latest record in sql
SQL
0 vote211 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
0 vote286 views1 answer
Oracle db get table sizes
SQL