/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

3 votes390 views2 answers
Synonym oracle
SQL
4 votes343 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote353 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote315 views1 answer
How to get n result in sql
SQL
0 vote365 views1 answer
Select sql in descending order
SQL
0 vote338 views1 answer
Postgres set default schema
SQL
0 vote287 views1 answer
Oracle function select into
SQL
19 votes343 views6 answers
Sql create table
SQL
0 vote344 views1 answer
How to set sql_mode for a query in CI model
SQL
0 vote330 views2 answers
Insert into
SQL