/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

5 votes358 views1 answer
Sql table columns
SQL
1 vote383 views1 answer
How not to sort by average rating
SQL
0 vote355 views1 answer
Load data infile mariadb slow
SQL
10 votes371 views4 answers
Mysql if else
SQL
0 vote329 views1 answer
Drop column from local database postgres pgadmin
SQL
11 votes334 views1 answer
Oracle insert into where
SQL
21 votes326 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
3 votes352 views1 answer
Laravel database Using Named Bindings
SQL
2 votes411 views2 answers
Python escape string for sql
SQL
0 vote354 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL