/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

-1 vote217 views1 answer
Sql syntax create timestamp column
SQL
0 vote232 views1 answer
Sql shell psql cannot enter password
SQL
-1 vote230 views1 answer
Su: Authentication failure mysql
SQL
0 vote226 views1 answer
Sqlcmd no headers
SQL
-1 vote226 views3 answers
SQL to LINQ converter
SQL
1 vote238 views1 answer
Sql server today minus n
SQL
0 vote226 views1 answer
Value of sold product using having and group by in sql
SQL
1 vote214 views5 answers
Sql 2nd highest salary
SQL
8 votes250 views1 answer
Oracle search text in all packages
SQL
0 vote219 views1 answer
Call function in query sql server
SQL