/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

2 votes139 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote109 views1 answer
Sqlite explain plan
SQL
0 vote124 views1 answer
Migration graphql
SQL
0 vote112 views2 answers
MySQL top percent
SQL
1 vote126 views1 answer
Rermove categories woocommerce sql
SQL
0 vote139 views1 answer
Where field is null sql knex
SQL
-1 vote128 views1 answer
Mysql change database charset and collation
SQL
5 votes105 views1 answer
Sql first day of current year
SQL
0 vote77 views1 answer
Mysql collation for all languages
SQL
0 vote107 views1 answer
How to find unique key in sql
SQL