/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 vote341 views1 answer
Postgresql print variable
SQL
0 vote395 views1 answer
How to find sql server installation folder
SQL
0 vote359 views1 answer
Merge clause with inner join
SQL
0 vote356 views4 answers
Mysql desactivar trigger
SQL
3 votes329 views2 answers
Oracle sql drop sequence
SQL
1 vote355 views1 answer
Rails run native ssql query
SQL
3 votes354 views1 answer
Fk in insert mysql
SQL
0 vote374 views1 answer
How to print some string in mysql
SQL
4 votes349 views2 answers
Bulk kill mysql processlist
SQL
0 vote314 views1 answer
Create duplicate table in postgresql
SQL