/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 vote297 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
0 vote334 views1 answer
How to remove quotes from a string in ssis load file
SQL
1 vote324 views1 answer
Continue in sql
SQL
5 votes342 views1 answer
Oracle nls session
SQL
0 vote305 views1 answer
Where in clause tsql
SQL
1 vote330 views1 answer
Mysql datetime with timezone offset
SQL
1 vote325 views1 answer
Declare table variable
SQL
1 vote491 views1 answer
Postgres upgrade to superuser
SQL
0 vote324 views1 answer
Psql attribute cannot login
SQL
0 vote310 views1 answer
Data types mysql vs postgresql
SQL