/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 vote175 views2 answers
Homebrew nysql launch
SQL
1 vote159 views1 answer
How to use a trigger to validate input data
SQL
0 vote175 views1 answer
Sqlite insert or update
SQL
0 vote198 views1 answer
Calculer pourcentage mysql
SQL
2 votes155 views1 answer
Oracle run_duration average
SQL
0 vote175 views1 answer
Postgresql auto increment not working
SQL
2 votes151 views2 answers
How to create an empty table from an existing table
SQL
0 vote179 views1 answer
PGSQL dynamic table name
SQL
4 votes142 views1 answer
Sql list users and roles
SQL
0 vote188 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL