/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 vote324 views1 answer
Setval postgres example table id
SQL
0 vote336 views4 answers
Rownum in sql
SQL
1 vote333 views1 answer
Retrieve meaning
SQL
0 vote348 views2 answers
Replace null with 0 in sql
SQL
0 vote329 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
3 votes320 views1 answer
Oracle user privileges
SQL
2 votes332 views1 answer
How to create sql database
SQL
0 vote344 views1 answer
Oracle cpu metric
SQL
0 vote326 views1 answer
18446744073709551615 mariadb left join order by
SQL
0 vote329 views1 answer
Import sql inside hide sql
SQL