/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 vote266 views1 answer
Sql query for login with email or username
SQL
0 vote277 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote256 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote202 views1 answer
Calculate age in sql
SQL
0 vote206 views1 answer
Mysql function variable
SQL
2 votes236 views1 answer
Find column in all stored procedures sql server
SQL
0 vote199 views1 answer
How to add session data into mysql database from button
SQL
0 vote267 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote197 views1 answer
Sql count null as 0
SQL
0 vote188 views1 answer
Mysql group rows with same value
SQL