/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 vote201 views2 answers
Dumping sql table
SQL
0 vote205 views1 answer
Connect postgresql using a connection string
SQL
22 votes182 views4 answers
Show list of users in mysql
SQL
0 vote204 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote182 views1 answer
T-sql update table variale
SQL
7 votes280 views2 answers
Sql empty table
SQL
1 vote184 views1 answer
How to change owner in postgres
SQL
0 vote200 views1 answer
Sql out file formate
SQL
0 vote177 views1 answer
Mysqlcli how to load external sql file
SQL
3 votes180 views2 answers
Sql paging query
SQL