/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

4 votes189 views2 answers
Sql select except null
SQL
0 vote233 views1 answer
Java sql timestamp now
SQL
3 votes198 views1 answer
Sql cast to integer
SQL
0 vote210 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
6 votes211 views1 answer
Oracle rank
SQL
0 vote202 views1 answer
EnvironmentError: mysql_config not found
SQL
10 votes213 views4 answers
Mysql if else
SQL
7 votes196 views2 answers
Mysql db size
SQL
0 vote201 views1 answer
Count the table indatabase
SQL
0 vote227 views2 answers
How to install psql in ubuntu
SQL