/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 vote136 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote428 views1 answer
How to connect .sql data set to powerbi
SQL
6 votes144 views1 answer
Oracle rank
SQL
2 votes148 views4 answers
2nd highest salary in mysql
SQL
0 vote130 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote130 views1 answer
How to get n result in sql
SQL
1 vote139 views1 answer
Install postgresql on raspberry pi
SQL
8 votes90 views2 answers
Alter column name in mssql
SQL
0 vote145 views1 answer
Postgresql replace html tags from string
SQL
3 votes147 views1 answer
Mysql replace string in table
SQL