/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 vote276 views1 answer
Mysqli_connect using prepare statement
SQL
1 vote276 views1 answer
Group_concat max length mysql
SQL
0 vote267 views1 answer
Convert rows to columns in sql server
SQL
0 vote255 views1 answer
Mysql select where field is a value
SQL
20 votes269 views5 answers
Sql show tables
SQL
10 votes255 views2 answers
Forgot my mysql password mac
SQL
-1 vote250 views2 answers
On update cascade
SQL
12 votes246 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote253 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote289 views1 answer
Netstat -tln mysql
SQL